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
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