How do i check a field in a table is null or empty in access2003

A

Anesh

hi,
i have used a macro in Access'03, and given the condition
[Reports]![repCSMCFax]![Agency]<>" " but this returns a "Type Mismatch"
error.
Where as the same cond works in Access 2.0. Please can you suggest a way to
check is the field is empty or null . I have used this condition to help
print a report by the name "repCSMCFax" is the field is not Null or empty and
has a agency name "POLI" in the agency field. Thanks in advance.
Best regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To write a condition to check for empty or null fields in access'0 2
I want to check a field of table is "Null" or "Empty" in Access'03 5
Type Mismatch in Macro with empty string/null value 7
Macro to respond to Empty Field or Control 1
Checking for, then listing Null/empty fields in a message box 0
Updateing a record with a Null value field, fails? 5
WHERE clause for a NULL/Empty field 2
Type Mismatch with Option Group 1

Top