Hi there, I am currently developing a solution for my A2 ICT project.
I have a report in which I need 2 components called "Address Line 1" and "Address Line 2" to be hidden for each tuple/record which has it's "Home Appointment" value as true. However, this is only to occur on an tuple/record basis.
Here is a picture to illustrate the situation:
www[DOT]dl[DOT]dropbox[DOT]com/u/34753331/appointments.png
(please replace each "[DOT]" with an actualy full stop ".")
Is there a VBA solution to this or can it be done more simply?
Thank you.
I have a report in which I need 2 components called "Address Line 1" and "Address Line 2" to be hidden for each tuple/record which has it's "Home Appointment" value as true. However, this is only to occur on an tuple/record basis.
Here is a picture to illustrate the situation:
www[DOT]dl[DOT]dropbox[DOT]com/u/34753331/appointments.png
(please replace each "[DOT]" with an actualy full stop ".")
Is there a VBA solution to this or can it be done more simply?
Thank you.