Kayleigh
Member
- Local time
- Today, 09:53
- Joined
- Sep 24, 2020
- Messages
- 706
Hi,
Have not worked much with reports but would imagine the VBA to be quite similar to that of forms?
I am attempting to display certain controls based on a field value so my code was something like:
Select case Me.trade
Case 1
Me.fldNotes.visible = true
Case 2
Me.fldDescription.visible = true
End select
I did not see the .visible property as an option when typing the VBA so it looks like this would not work. Can anyone suggest a work-around for this?
Have not worked much with reports but would imagine the VBA to be quite similar to that of forms?
I am attempting to display certain controls based on a field value so my code was something like:
Select case Me.trade
Case 1
Me.fldNotes.visible = true
Case 2
Me.fldDescription.visible = true
End select
I did not see the .visible property as an option when typing the VBA so it looks like this would not work. Can anyone suggest a work-around for this?