In Access VBA, you have to add an empty string to the value being compared in order to get consistent results. For example, add &"" to your string varilable or it's code equivalent &vbNullString. Then compare to an empty string or verify it's length to 0 with Len.
This article discusses a programming technique I used in a Microsoft Access database application to display a multiple page PDF document and make it position itself at a specific page.
Queries on a Microsoft Access database linked to MySQL tables failed with errors like ODBC--data out of range and the VBA code not recognizing fields from a sub-form query definition, insisting that it could not find the fields that I was referencing (Microsoft Access cannot find the field "fieldname" referred to in your expression).
7 years ago
KB Post
2796 Hits
New Microsoft Access Knowledge Base Post...
Share your knowledge with the WORLD! In addition to adding comments to existing posts, you can post knowledge you've acquired. We welcome full articles (intro with screen shots), general posts (shorter), and tidbits (tips, FAQs, definitions, etc.).