hiding money controls on forms and reports

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

hiding money controls on forms and reports

Post by Pat »

Is there a way to hide controls that show money values from particular users on forms and reports.
At this stage i have a table that shows controls for forms and reports and at the open event i hide these controls if necessary.
Is there an easier way to do this?

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: hiding money controls on forms and reports

Post by HansV »

A table-driven approach is probably the most flexible solution. Once you have set it up, it is easy to maintain, and you can deploy the same frontend to all users.

If the setup is stable, you might create two different frontends instead: one with forms and reports showing all fields, and one with forms and reports displaying a limited set of fields. You wouldn't need code to show/hide controls, but if the setup changes, maintaining two different frontends could quickly become a nightmare.
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: hiding money controls on forms and reports

Post by Pat »

Thanks, it has been in and working for months, it was just a question as to what the options were.
Seems i selected the right way to go.
Thanks Hans