Microsoft Access Quick Queries #18: Paste Behavior, Text Box Margins, Vertical Alignment, More...

Welcome to another TechHelp Quick Queries video brought to you by Access Learning Zone. I am your instructor, Richard Rost. Quick Queries videos are for me to answer your questions that may not need a whole video themselves. In today's video...
TOPICS:
Access form paste location behavior
Adjusting Access form paste behavior
Access text box margins and padding
Effect of Aptos font on forms
How to change font in Access forms
Vertical alignment in command buttons
Adding line breaks in command buttons
Creating transparent buttons
Buttons on reports in Access
Report view vs. print preview
Object dependencies in Access
Using undefined functions in Access
Avoiding duplicated module and function names
Multi-select options in Access
Multi-valued fields in Access
Advantages and disadvantages of multi-valued fields
Using subforms for related data
Naming conventions in Access
Spaces in table and field names
Singular vs. plural table names
Deleting unused objects in Access
Renaming objects as a safe deletion strategy
Effects of indexing in Access
Balancing indexed fields and performance
Indexing strategies and best practices
Using Access runtime version
Managing Access runtime errors
Comparing ACCDE and full Access versions
Ensuring consistent Access versions in a network
Handling Access database corruption
Creating new databases to fix corruption
Avoiding development on networked databases
Dangers of shared file systems for Access databases
LEARN MORE:
599cd.com/QQ18
PREVIOUS QUICK QUERIES VIDEOS:
Quick Queries: 599cd.com/QuickQueries
LINKS:
Transparent Buttons: 599cd.com/TransparentButtons
Multivalued Fields : 599cd.com/MVF
Subforms: 599cd.com/Subform
Relationships: 599cd.com/Relationships
Relational Combo: 599cd.com/Relational
Manage Rental Inventory: 599cd.com/RentalInventory
COURSES:
Multi Select in Access Developer 15: 599cd.com/ACD15
Bill To Ship To Access Advanced 5: 599cd.com/ACA5
Access Relationship Seminar: 599cd.com/RelationshipSeminar
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMember
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Access form pasting, cut and paste behavior, property sheets in Access, padding settings Access, controlling vertical alignment button, transparent buttons Access, print button on report, name conflicts Access modules, multiple values in combo box, multi-select list box Access, multi-valued fields Access, indexing database tables, creating relationships Access
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@neil9655]

I love Richard's personality

[@fontie38]

Whoah😮

[@gregoryjeffries8475]

What Shadow.Dragon said. Have more of statement than question, would think runtime not required if db is compiled, ie. An exe (compiled) database is created for distribution.

[@Shadow.Dragon]

Richard, thanks for another great Quick Queries video! I total agree with @clemdacier1402. I love your enthusiasm for Access. It makes you a great teacher! And thanks for the shout out!!!

[@amyoakes9703]

Richard - I love your videos. I spend many hours trying to decipher Microsoft's page and one of your 20 minute help videos on vba cleared most of my questions (I'm still working on syntax between SQL and vba and internal Queries). In my database I'm trying to figure out how to keep all the links straight in my head. Sometimes the relationships look like spaghetti code. any tips for getting them aligned so they are readable?

[@alializadeh8195]

Thanks