Format Controls (Access2002)

Topic

New Reply

When a field receives focus; the background color becomes the fore color and fore color becomes the background color; can you override this function?

Reply | Quote

Replies

Most users find this very useful as an indication that the field contents are selected.
You can specify whether the entire field is selected in the ‘Behavior Entering Field’ section of the Keyboard tab of Tools | Options…
If you select ‘Go to start of field’ or ‘Go to end of field’, the color inversion won’t occur.

Reply | Quote

Thanks very much for the information; however we are using a CITRIX Client to push out many databases to all our customers. So whenever I make changes to the ‘Behavior Entering Field’ section of the Keyboard tab of Tools | Options… it will affect all the other databases. I don’t control all the Databases; So is there a way to do this for a specific database when it opens or to specific Form when it opens?

Reply | Quote

Why in heaven’s name do you want this? It will be very confusing if the user cannot see which control has the focus.

Reply | Quote

I must apologies; I need to be a bit more detailed; on a previous post, you explained how to create labels that I move to the back of the each field on my form; the color of the labels is white. I chose a background color of purple and fore color of black for all of the text boxes and combo boxes; then I change the properties on text boxes and combo boxes Back Style to Transparent. When the I use the mouse to move to the field; the fore color is black and the background color is purple. Looks great and the users know where the cursor is at; but after a second or two, the field color inversion occurs. Then fields has a black background and a purple fore color combination does not look good; regardless; Is there a way to override the color inversion?

Reply | Quote

All you need do is change the behavior entering field for your database in Tools–>Options–>Keyboard. The default is usually Select entire field. Change it to Got to start of field or Go to end of Field, whichever is more appropriate.

You should be aware, however, that this means that the user can’t replace the value in the field by simply beginning to type. Instead, they have to clear the field or select the entire contents before replacing the value.

Reply | Quote

You could create an On Got Focus event procedure for each text box / combo box:

Private Sub ControlName_GotFocus()
Me.ControlName.SelLength = 0
End Sub

where ControlName is the name of the trxt box / combo box.

Reply | Quote