Results 1 to 9 of 9
  1. #1
    twgonder is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    658

    Get lost in entry, change background?

    In forms, the cursor is quite thin in textboxes. Is there a way to make it bigger?
    It might also be nice to change the background color to indicate which control has the focus.
    But, I don't want to go and make dozens of code bits for each control when getting or losing focus.

    Is there one form event that would work to catch all such focus events
    so that one bit of code can change it for each control when that control gets/loses focus?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    It might also be nice to change the background color to indicate which control has the focus.
    But, I don't want to go and make dozens of code bits for each control when getting or losing focus.
    usual way is to use conditional formatting. You can select all the controls and apply the rule in one go. The rule is 'field has focus', choose a back colour to suit

    Note some controls such as check boxes cannot be conditionally formatted

    In forms, the cursor is quite thin in textboxes. Is there a way to make it bigger?
    not so far as I am aware - if there is it will be a windows setting somewhere

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    if there is it will be a windows setting somewhere
    You can change the text cursor thickness
    Attached Thumbnails Attached Thumbnails cursor.PNG  
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    twgonder is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    658
    @Welshgasman Made no difference to the Access textbox cursor. Even after restarting Access.

  5. #5
    twgonder is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    658
    Quote Originally Posted by CJ_London View Post
    usual way is to use conditional formatting. You can select all the controls and apply the rule in one go. The rule is 'field has focus', choose a back colour to suit ...
    That sounds vaguely familiar. I think someone with NiftyAccessTips, or some name like that, posted on that here or in another forum. I'll see if I can find the details of how. Thanks for the memory jog.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Quote Originally Posted by twgonder View Post
    @Welshgasman Made no difference to the Access textbox cursor. Even after restarting Access.
    Really?, worked for me. No need to restart Access, took effect immediately.
    Attached Thumbnails Attached Thumbnails twgonder.PNG  
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,654
    Worked for me too. Never realized all those options were there. Thanks Gman.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  8. #8
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Quote Originally Posted by moke123 View Post
    Worked for me too. Never realized all those options were there. Thanks Gman.
    I did not either, I just went searching.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  9. #9
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    I'll see if I can find the details of how
    I told you how - or do you need detailed instructions as to where to find the conditional formatting button on the ribbon?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Change Color Background frm list
    By Giulio Benvenuti in forum Access
    Replies: 2
    Last Post: 03-22-2021, 02:56 AM
  2. Change background color in field
    By jrm in forum Reports
    Replies: 8
    Last Post: 12-23-2020, 10:16 AM
  3. Replies: 5
    Last Post: 08-25-2018, 04:55 PM
  4. Change Form Background Colour
    By Emma35 in forum Forms
    Replies: 11
    Last Post: 01-25-2016, 06:12 AM
  5. Change the colour of a form background
    By r_e_v_a_n_s in forum Forms
    Replies: 0
    Last Post: 11-15-2005, 03:39 AM

Posting Permissions

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