Hide System Fileds in table

[Abe Katz]

Hello All,
How can I hide/show the system fields in a table i.e. s_Generation and
s_GUID?
Thanks
Abe

 

[Jeff Boyce]

You posed your question in a newsgroup dedicated to Access forms. I'll
assume you want not to see those fields in your form, rather than "hiding"
them in the underlying table. After all, you don't want your users mucking
about in the tables directly...

If you need/want the fields attached to the form, but not visible, you can
set the control's .Visible property to False.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[John W. Vinson]

Hello All,
How can I hide/show the system fields in a table i.e. s_Generation and
s_GUID?
Thanks
Abe

In a Table? AFAIK you can't. But then users should never see table datasheets
in a production database anyway; they should see only Forms, and on a form you
can just not display these fields.