hide combo in non edit from

[Guest]

I got a form that is non edit, what I need to know is how to hide the combo
control in this state, the combo control comes from the table, I tryed using
a txt box but that is showing the id of the field from where the this part of
the record is coming from, As I never set this database up and only helping
out with it, so I'm not will to change any of the table to fix up where it
poins to the wrong field

 

[Duane Hookom]

You can hide the combo box and add a text box. Set the text box control
source to something like:
=[YourComboBoxName].Column(1)
You may need to change the column number and of course use your combo box
name.

An alternative is to add the table containing the text value to your form's
record source.

Ideally, you shouldn't be using lookup fields in tables.

 

[Guest]

Thanks for that, I opted to go for the text box and hide the combo box, set
the combo to not visable and put it down the bottom of the fome as small as
possable.
Thanks Again

You can hide the combo box and add a text box. Set the text box control
source to something like:
=[YourComboBoxName].Column(1)
You may need to change the column number and of course use your combo box
name.

An alternative is to add the table containing the text value to your form's
record source.

Ideally, you shouldn't be using lookup fields in tables.


--
Duane Hookom
MS Access MVP

I got a form that is non edit, what I need to know is how to hide the combo
control in this state, the combo control comes from the table, I tryed
using
a txt box but that is showing the id of the field from where the this part
of
the record is coming from, As I never set this database up and only
helping
out with it, so I'm not will to change any of the table to fix up where it
poins to the wrong field