how can I hide a field?

[imnewtoaccess]

I have a form with subforms, and they pull data from tables that I have set
up. There's information on the tables that I don't want shown in the form,
but I don't want to delete it since it may mess it up. The subforms are shown
in Datasheet view. Anyone know how I can leave the info there but make it not
visible?

 

[tina]

just remove the control(s) that are bound to the field(s) that you don't
want to display. the data is still available to be read and/or edited
programmatically if necessary, because it's *not* excluded from the form's
RecordSource.

hth

 

[Jeff Boyce]

In addition to Tina's suggestion, consider using a query as the record
source for your form. That's another way you can choose to include/exclude
fields that exist in the table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[scubadiver]

Put focus on the field,

right click

properties

"format" tab

find "visible" and change it to "no"


--
http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org

 

[tina]

that doesn't work when the form is in Datasheet view.

hth