By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,192 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,192 IT Pros & Developers. It's quick & easy.

Removing Dropdown Arrow From Locked Field

P: n/a
I have a locked field on a tabular form that maps to a lookup table.
However, since the field is view only, I'd like to remove the lookup
dropdown arrow.

Any ideas.

Thanks,

SteveM

Jul 27 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
There are fudges that place a graphic over part of the combo, or a text box
on top of it bound to:
=[Combo1].Column(1)
or whatever.

But a simpler solution might be to create a query that contains both your
main table and also the lookup table, and use the query as the Record Source
of the form. You can then include the value from the lookup table, so you
can use a text box instead of the combo.

(One potential hazard here is if any of the lookup table's fields have a
Default Value assigned, you may need to clear that so you don't run into
problems adding new records to the form.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"SteveM" <sb****@vzavenue.netwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...
>I have a locked field on a tabular form that maps to a lookup table.
However, since the field is view only, I'd like to remove the lookup
dropdown arrow.

Jul 27 '06 #2

P: n/a
Allen,

Thanks Much,

SteveM

P.S. Perth Austrailia - the internet is a wonderful thing.

Allen Browne wrote:
There are fudges that place a graphic over part of the combo, or a text box
on top of it bound to:
=[Combo1].Column(1)
or whatever.

But a simpler solution might be to create a query that contains both your
main table and also the lookup table, and use the query as the Record Source
of the form. You can then include the value from the lookup table, so you
can use a text box instead of the combo.

(One potential hazard here is if any of the lookup table's fields have a
Default Value assigned, you may need to clear that so you don't run into
problems adding new records to the form.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"SteveM" <sb****@vzavenue.netwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...
I have a locked field on a tabular form that maps to a lookup table.
However, since the field is view only, I'd like to remove the lookup
dropdown arrow.
Jul 27 '06 #3

P: n/a
Can't you just change the field to a text box? Format ->Change To ->
Text Box

"SteveM" <sb****@vzavenue.netwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...
>I have a locked field on a tabular form that maps to a lookup table.
However, since the field is view only, I'd like to remove the lookup
dropdown arrow.
Jul 27 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.