Opening Form in Read Only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sue gray - 03 Dec 2007 21:31 GMT

I am openinging a form in read only from a command button. That works fine.
The form contains drop down boxes. How do I hide the drop down arrow and
contents. It should only show the contents of the field.

Thanks.

Reply to this Message

Steve Schapel - 03 Dec 2007 21:55 GMT

Sue,

One approach here would be to make a textbox corresponding with each
combobox, and place on the form in the same position as the comboboxes,
one on top of the other.

Then you would need to use code to set the Visible property of each
combobox to No, and the textboxes to Yes, as part of the process of
opening the read-only instance of the form.

Signature

Steve Schapel, Microsoft Access MVP

> I am openinging a form in read only from a command button. That works fine.
> The form contains drop down boxes. How do I hide the drop down arrow and
> contents. It should only show the contents of the field.
>
> Thanks.

Reply to this Message