Link to home
Create AccountLog in
Avatar of marian68
marian68

asked on

report in Access 2003

Is it possible in a report in Access 2003 to have the following condition between 2 controls: 1st control is visible if the 2nd control is not null or empty and 1st control is not visible if the 2nd control is null or empty?
Thank you
ASKER CERTIFIED SOLUTION
Avatar of Helen Feddema
Helen Feddema
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of marian68
marian68

ASKER

Thank you Helen
Where do I have to put this code in my report?
Thank you
In the meantime I found the place for the code.
Please tell me if I add another field what would be the code:
1st control is visible if the 2nd control or the 3rd control is not null or empty and 1st control is not visible if the 2nd control and the 3rd control is null or empty?
Thanks a lot
  If Nz(Me![COMMENTS] <> "" Then
I am receiving a syntax error for this line.
Thank you
I found the syntax error.
Please tell me if I add another field what would be the code:
1st control is visible if the 2nd control or the 3rd control is not null or empty and 1st control is not visible if the 2nd control and the 3rd control is null or empty?
Thanks a lot
Anyone there!
Thank you
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account