I have a text field on a form which gets its integer value using a DLookup to a query expression. When I create a macro to test if this is greater than 20 I get a type mismatch error.
I have set the format of the text field to general number and tried CInt function. Here I get a condition of False even when it should be true. If I use If [Forms]![frmMain]![txtAMFull] Is Not Null then that works. The macro builder also insists on me using Forms!frmMain even though the field is on the main form. Driving me mad.