hide drop down in query result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table drop-down values disappear in query 7
drop down menu in query 1
Access 2007: Need more info on 'concatenante fields' 1
Queries Access 2003 use a Drop down box for selection of querycrit 1
LIKE function help needed in combobox in the form 3
Quering a drop down column from a table 2
Dynamic Access Table from Form 0
Query for All 4

Back
Top