Making Date Fields Optional in Access Queries
If you would like to give a person optional choices in a date parameter, and don’t want to use if statement logic, the NZ function is the way to go. Recently in Access, I had to write a query that was getting criteria from a form called frmChoice. I wanted to give my database user [...]
A Better Way to Create Lookup Fields
You might be tempted, when thinking about creating a Lookup field in Microsoft Access, to use the Wizard.
Don’t.
It involves too much cleanup work after you are done. For example, if you use the Lookup Wizard, you must destroy any existing relationship between the two tables. During the running of the wizard, you will see a [...]
Can You Wrap Text in an Access List Box?
Recently I was asked if you can wrap text in a list box on an Access form. The short answer is no.
However, you could try putting an unbound text box near the list box. In the text box properties set the Control Source to point back to the list box property. In the image below, [...]
