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

[Guest]

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

 

[Guest]

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

 

[Joseph Meehan]

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

If you are getting an error message, it would appear that some part of
your application is using them. What exactly does the error message say?

 

[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.

 

[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

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]

 

[Guest]

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