Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19

Search for a control in form

  1. #16
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    You're right, it's late, as you discovered. The email is a bit different than your current post, yes?
    Thank god for the editor.

    Hmmm, you don't mind all that flashing when you type? Users better not have epilepsy!
    You know, I would have chosen a different color than that blasted yellow!

  2. #17
    LonghronJ is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Jul 2015
    You guys are amazing. This is awesome.

  3. #18
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Anchorage, Alaska, USA
    I was just trying to keep it simple so the OP could follow. I maybe would have regrouped/arranged the buttons into logical groupings.

    I did try hex for the color, but the VBA code error-ed. When I changed to a long, it worked.
    Apparently, in a form you must use hex and in VBA you have to use a long integer. Since this seemed a one off, I just used the long in the tag property.
    You win...lets have a cold one.
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  4. #19
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    I believe I get your drift. You used long 814609 and I used hex 116E0C from the property sheet. I plugged your number into W10 calculator and converted to text and got C 6E11 (0C6E11). Note that in the property sheet, hex RGB values are reversed! I read about this at the link documented in my code but never actually encountered any evidence of it before now.
    Joining you now. Bottoms up!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 03-09-2018, 10:11 PM
  2. Replies: 3
    Last Post: 03-18-2016, 04:02 PM
  3. Replies: 4
    Last Post: 02-18-2016, 11:06 AM
  4. Replies: 2
    Last Post: 01-16-2015, 04:56 AM
  5. Wildcard search within ComboBox to control RowSource
    By CaptainKen in forum Programming
    Replies: 22
    Last Post: 05-16-2012, 01:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums