Display only form - field is 'black'

[Gkirkup]

I have a form that is used for display only - no data entry or editing takes place on the form. However, the first field on the form is 'black' ready for editing. How do I set up the field or form so that it's truly display only - all fields are 'white'?

Robert

 

[boblarson]

I think you mean that the field is highlighted. If you open the form in design mode and, in the form's properties, select
AllowAdditions No
AllowDeletions No
AllowEdits No

Then, nothing can be entered or edited, regardless of what it looks like.

 

[missinglinq]

To stop the field from being hilighted:

Goto Tools > Options > Keyboard

Under Behavior Entering Field I suspect you'll see Select Entire Field checked. Instead, check Go To Start of Field and then click on OK. The text should no longer be "black."

 

[boblarson]

To stop the field from being hilighted:

Goto Tools > Options > Keyboard

Under Behavior Entering Field I suspect you'll see Select Entire Field checked. Instead, check Go To Start of Field and then click on OK. The text should no longer be "black."

That will work for your own computer, but those are a per computer setting, so others might not see it like you do.

So, my post will take care of making the form read only, and missinglinq's post will take care of the way it's displayed.

 

[Gkirkup]

Bob: I tried setting the three settings to 'No', but the field is still highlighted. Only appearance matters in this case, as this is for a 'display screen', mounted on a wall.

Robert

 

[boblarson]

Did you try missinglinq's suggestion?

 

[missinglinq]

You're right, Bob! To work on any computer, regardless of the user's settings, he'd need to do this on the first control to get focus. Presumably, since there's no editing going on, no one will be tabbing thru the fields. He could, of couse, use the same code on every text control:

Private Sub FirstTextBox_GotFocus()
   FirstTextBox.SelLength = 0
End Sub