Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Format Controls (Access2002)

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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format Controls (Access2002)

    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.

  3. #3
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format Controls (Access2002)

    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?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format Controls (Access2002)

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

  5. #5
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format Controls (Access2002)

    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?

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Format Controls (Access2002)

    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.
    Charlotte

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format Controls (Access2002)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •