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

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" <sbmack [at] vzavenue.net> wrote in message
news:1154008474.102965.182130 [at] 75g2000cwc.googlegroups.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.

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" <sbmack [at] vzavenue.net> wrote in message
> news:1154008474.102965.182130 [at] 75g2000cwc.googlegroups.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.

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

"SteveM" <sbmack [at] vzavenue.net> wrote in message
news:1154008474.102965.182130 [at] 75g2000cwc.googlegroups.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.