hide field on subform

[Souris]

I have code and description fields in my query.
I need the code on the datasheet subform and only want to show the
description to the user.

I tried to use visible to false, but it still shows the field on the user
interface.

Are there any way to hid field on the subform, but must exist in the query
and subform for the access from VBA code.


Your help is great is great appreciated,

 

[Allen Browne]

You cannot selectively hide a control in only some rows of a continuous form
or datasheet.

Instead, use conditional formatting (such as white text on a white
background.)

 

[Klatuu]

Open your form in form view

Select column(s) you want to hide.
From the main menu, Format, HideColumns

Then save the form. The columns will then show in design view, but not form
view.

 

[Souris]

Thanks,

Does it support Access 2003?
I do not see hideColumns on the format menu on my Access 2003.

Thanks again,

 

[Klatuu]

I am using 2003. It is on my menu when the form is open.

 

[Souris]

Thanks millions,

I found the menu.
I thought that the menu is available on the design time.

Thnks again,

 

[Klatuu]

No, you have to hide the column and save the form while it is open.