How can I hide fields from tables or forms???

R

rigby

i need to hide some fields in a DB that I dont need but cant delete due to
their relationship in queries and VBA. i have tried deleting them, but i just
get error messages. please help
 
S

Sheila D

You should be able to remove them from forms in design view assuming that
they aren't being used for any calculations within the form itself. This
means that any historical data is stored in the table but will never be seen
again on the forms. I strongly suggest you make a back up copy of the forms
before you remove the fields just in case it impacts somewhere else in your
database.

Sheila
 
R

Ron Hinds

Or they could just set the Visible property to No on those controls rather
than delete them. That way the fields would still be there in the event they
are referenced elsewhere.
 
J

John Vinson

i need to hide some fields in a DB that I dont need but cant delete due to
their relationship in queries and VBA. i have tried deleting them, but i just
get error messages. please help
Click to expand...

If you just want to hide them from user view, you don't need to delete
them; just give the User forms and reports based on queries which
don't include the fields. Users shouldn't be looking at table
datasheets in any case!

John W. Vinson[MVP]
 
R

rigby

Thank you so mych Ron. Everybody has been very helpful which i really
appreciate, but your response was the exact answer i was looking for. thank
you!

Rigby
 
Top