Hi,

I am looking for a way to customize fields to be hidden or not depending on
user in forms or reports of MS access

Any idea ?

I wanted to explore the customisation of each query but there must be an
easier way to save personal parameters somehow so that the user would go
through the forms and hide the non necessary fields once and we would then
save somewhere these settings for each user.

Has anybody already experienced such a request ?

hi,
if you are trying to hide fields on the forms you can do so using the
VISIBLE property of the fields.

if you want to hide fileds dynamically and provide this option to the users
of the forms, then you can add code to the form that will manipulate the
VISIBLE property for the users. You can then create a separate "user
settings" table and save the user preferences in this table. You will have to
add code that users are recognized and their settings are pulled on the form
open event or at the application start.

Regards,

-----------------------------------------
http://www.Designing-Systems.com
Email. (E-Mail Removed)
-----------------------------------------------

"LOLO" wrote:

> Hi,
>
> I am looking for a way to customize fields to be hidden or not depending on
> user in forms or reports of MS access
>
> Any idea ?
>
> I wanted to explore the customisation of each query but there must be an
> easier way to save personal parameters somehow so that the user would go
> through the forms and hide the non necessary fields once and we would then
> save somewhere these settings for each user.
>
> Has anybody already experienced such a request ?
>

Many thanks,

we will try this. I still have a question.
Assuming we maintain user preferences in a table, how can we read the result
of the query on this table and use these results in the code ?