hide drop down in query result

B

Blade370

Hi,
I have a drop down selection box in my master table. However when I perform
a query on this table I want to show that field without the drop down
selector being visible. Is this possible???

Thank you
 
W

Wolfgang Kais

Hello Blade370.

Blade370 said:
Hi,
I have a drop down selection box in my master table. However when I
perform a query on this table I want to show that field without the drop
down selector being visible. Is this possible???
Click to expand...

Yes. In design view of the query, open the properties window of the field,
select the lookup tab and set the Display Control property to Textbox.
 
B

Blade370

Thanks Wolfgang that worked a treat.

Wolfgang Kais said:
Hello Blade370.



Yes. In design view of the query, open the properties window of the field,
select the lookup tab and set the Display Control property to Textbox.
Click to expand...
 
Top