Microsoft Access Tutorial: How To Resize Form Fields Dynamically Using MS Access VBA

Microsoft Access Tutorial: How To Resize Form Fields Dynamically Using MS Access VBA

I often see many poorly designed Access forms that just make it hard and clumsy to navigate and use. One particular element (and there are many) is the lack of area space for a text box control like comments or notes that require some intervention in order to edit the content properly.

Check out this Microsoft Access tutorial provided by ‘599CD Computer Training’ who provide some good and free video tutorials about Microsoft Access databases. On this occasion, it’s the best part of ten minutes but worth watching all the way to the end.

httpvh://www.youtube.com/watch?v=TC1QjUyOXi8

There are some good pointers here and to avoid using the SHIFT + F2 function key to zoom in on an active text box control, the author has Continue reading “Microsoft Access Tutorial: How To Resize Form Fields Dynamically Using MS Access VBA”

Welcome to Microsoft Access Database Tutorial

Welcome to the Access Database Tutorial website that will show you how to use Microsoft Access Database by learning and managing this powerful application using the most effective techniques and tools available for visitors with very little or no knowledge to get you up and running without the need to learn all the ‘geek’ speak keeping it Jargon free that most trainers and consultants like to impress you with!

If you are new to Access or wish to know what is MS Access, please take a look at An Introduction To Microsoft Access.

Also, this website contains a blog, products on offer and free general tips to help users find out all about  latest news and articles I feel worth mentioning along with my recommendations of videos and books.

As a Thank You for Visiting…

Claim Your Free eBook NOW!

Enjoy and thank you for visiting!

Microsoft Access Tutorial: How To Create A Leading Dot List

Microsoft Access Tutorial: How To Create A Leading Dot List

If you wanted to generate a table of contents or a set of index pages, the format for this type of document tends to have leading dots connecting narratives with page numbers.

Using Microsoft Word or other word processors and DTP applications; generating these pages is a breeze. With Microsoft Access however, it simply doesn’t exist and to mimic such a document we need to be a little creative here. 

In this Microsoft Access tutorial, I’m going to create a report showing the company name, a contact name and the telephone number sitting (as right aligned) at the end of a dot leader line (see image below).

microsoft access tutorial string function

In fact, the telephone number may appear as right aligned but is in fact Continue reading “Microsoft Access Tutorial: How To Create A Leading Dot List”