Interface ideas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DZ - 20 Dec 2007 03:40 GMT

I have two things I want to

1. Create an interface on a form with static text that the user can't
select. This is for viewing only, so I don't want it to be selectable.The
text is too long for the form so I need to make it scrollable. I tried using
a unbound object frame but I got an OLE not registered error

2 Create an interface on a form with dynamc text. The text is actually SQL
for a selectable query. As it stands now, I am using a text box on one of the
pages of an Access tab control. I want the text to be selectable but the
problem I have is that the all the text become selected as soon as you select
that page of the tab stop . I tried settng the Tab Stop property to No but
the text still gets selected everything I select the page of the Tab control

Reply to this Message

Linq Adams - 20 Dec 2007 04:24 GMT

>1. Create an interface on a form with static text that the user can't
>select. This is for viewing only, so I don't want it to be selectable.The
>text is too long for the form so I need to make it scrollable. I tried using
>a unbound object frame but I got an OLE not registered error

Not sure exactly what you mean by “selectable.” If you mean you want it to be
Read-Only, then Goto Properties - Data and set Locked to Yes. They can click
into the field but can’t edit or delete the data. If the text in the textbox
is defined in the underlying table as a Memo datatype and the physical size
of the textbox on the form is fairly small, Access will automatically place
scrollbars on it.

>2 Create an interface on a form with dynamc text. The text is actually SQL
>for a selectable query. As it stands now, I am using a text box on one of the
>pages of an Access tab control. I want the text to be selectable but the
>problem I have is that the all the text become selected as soon as you select
>that page of the tab stop . I tried settng the Tab Stop property to No but
>the text still gets selected everything I select the page of the Tab control

To stop the selection of the data, got Tools - Options - Keyboard and change

"Behavior Entering Field" from "Select Entire Field" to "Go to beginning of
field."

Hope this helps!

Linq

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message

DZ - 20 Dec 2007 05:17 GMT

Hello and thanks for responding.

Im sorry for not being more clear.

For the first interface, I don't want the text to be highlightable and it
doesn't have to be clickable either. Changing the behavior upon entering a
field is not practical because this app will be distributed and I can't
control options on another persons version of Access and even if I could I
don't want to change that option globally.

For the second interface I DO want it selectable but I don't want the text
to be highlighted when I select the tab control page its on.

Thanks for any help

Reply to this Message

Rick Brandt - 20 Dec 2007 12:38 GMT

> Hello and thanks for responding.
>
[quoted text clipped - 11 lines]
>
> Thanks for any help

There is no native way to do what you want that I know of. A control that
allows scrolling has to be selectable.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message