hide field in a table

[Clueless]

I have a .mdb table with about 20 fields, half of which are "initial" fields
which do not need to be displayed unless the field before it is filled in.
Is there any way to hide those "initial" columns when a a new record is being
filled in until the field before it is filled in? If that is possible, then
is it possible when not clicked on any field, all fields are displayed? Code
- Macros - Settings resolutions welcome

 

[fredg]

I have a .mdb table with about 20 fields, half of which are "initial" fields
which do not need to be displayed unless the field before it is filled in.
Is there any way to hide those "initial" columns when a a new record is being
filled in until the field before it is filled in? If that is possible, then
is it possible when not clicked on any field, all fields are displayed? Code
- Macros - Settings resolutions welcome

A table is NOT the place for a user to be entering data into. In fact,
then entire table can be hidden, never to be seen by a user.

Aside from that, no, you cannot hide individual fields in a table.

The place to enter data is through a form. A form has controls which
can be made visible or not visible as data entry progresses. Using a
form, you can set various controls to not visible in the form's
current event ([Address].Visible = False), then make some or all
visible again in the AfterUpdate event of any control
([Address].Visible = True).

 

[John W. Vinson/MVP]

I have a .mdb table with about 20 fields, half of which are "initial" fields
which do not need to be displayed unless the field before it is filled in.
Is there any way to hide those "initial" columns when a a new record is being
filled in until the field before it is filled in? If that is possible, then
is it possible when not clicked on any field, all fields are displayed? Code
- Macros - Settings resolutions welcome

Well, first off - don't use a table datasheet for ANY interaction with
data. It's much too inflexible.

Instead, base a Form on the table (or on a query based on the table).
You can easily set the Visible property of some form controls to No,
and then set it to Yes in some appropriate form event (such as the
AfterUpdate event of the "before" field). You can do this with either
VBA code or a macro as you prefer.

 

[a a r o n _ k e m p f]

have you tried right-click HIDE on the column you want-- in the table
datasheet view?

regarding the 'dont let people enter stuff into tables'- this is a bad
solution.
the real answer is to move to SQL Server and just use views.

a) Jet doesn't have these inventions called 'views'
b) because you're using an obsolete database engine- you could not
utilize views to do this
c) these kids blame the frontend - for some shortcoming in JET
d) if you had views, it would work much better

with a view, you could filter so that susie could only see susies
records.
with a view you could filter a column so that nobody could SEE the
column; even though it is there.

with SQL Server, you can give permissions to a column so that only
people in HR can see the salary column
with Access, you're stuck, being forced to build forms to do this.

-Aaron

I have a .mdb table with about 20 fields, half of which are "initial" fields
which do not need to be displayed unless the field before it is filled in.  
Is there any way to hide those "initial" columns when a a new record isbeing
filled in until the field before it is filled in?  If that is possible, then
is it possible when not clicked on any field, all fields are displayed? Code
- Macros - Settings   resolutions welcome

A table is NOT the place for a user to be entering data into. In fact,
then entire table can be hidden, never to be seen by a user.

Aside from that, no, you cannot hide individual fields in a table.

The place to enter data is through a form. A form has controls which
can be made visible or not visible as data entry progresses.  Using a
form, you can set various controls to not visible in the form's
current event ([Address].Visible = False), then make some or all
visible again in the AfterUpdate event of any control
([Address].Visible = True).