Prev: Problem with color in subform
Next: Update a record
From: Abe Katz on 19 Mar 2010 10:43
Hello All,
How can I hide/show the system fields in a table i.e. s_Generation and
s_GUID?
Thanks
Abe


From: Jeff Boyce on 19 Mar 2010 11:18
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.

"Abe Katz" <abekatz(a)mindspring.com> wrote in message
news:OWey1K3xKHA.6140(a)TK2MSFTNGP05.phx.gbl...
> Hello All,
> How can I hide/show the system fields in a table i.e. s_Generation and
> s_GUID?
> Thanks
> Abe
>


From: John W. Vinson on 19 Mar 2010 17:38
On Fri, 19 Mar 2010 10:43:55 -0400, "Abe Katz" <abekatz(a)mindspring.com> wrote:

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

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Problem with color in subform
Next: Update a record