Results 1 to 3 of 3
  1. #1
    fra.gal is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    1

    Display Combobox with different text value format

    Hi all,
    I have a question regarding the possibility to display different text formats in a combobox list of values (coming from an associated table).
    I would like my list to be personalized; something like:
    ||USERNAME||


    |John|
    |Jack|
    |Mike|
    |Bill|

    ||USERNAME||
    |John|
    |Jack|
    |Mike|
    |Bill|

    Is it possible? this is because I would like to point the attention of the user on some important fields, that I need to have inserted in the DB.
    I know my example is quite simple but I wonder if there is a solution to my question.
    Thank you all
    Francesco

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,511
    I don't think you can change specific values in the combo list to bold(but could be wrong with later versions of Access). But maybe you could add some characters before and remove them after to highlight the ones you want?

    Maybe in the query that populates the combo box:

    ||USERNAME||
    John-*
    Jack
    Mike-*
    Bill

    Then in the combo box AfterUpdate event, strip away those extra characters
    Me.UserName = Mid(Me.UserName, 1, Len(Me.UserName)-2)

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

Similar Threads

  1. Replies: 3
    Last Post: 12-30-2016, 10:27 AM
  2. Field Display Format
    By MaineLady in forum Access
    Replies: 7
    Last Post: 09-03-2014, 08:56 PM
  3. Replies: 2
    Last Post: 07-09-2014, 06:41 PM
  4. combobox + conditional format
    By markjkubicki in forum Forms
    Replies: 4
    Last Post: 06-24-2014, 04:25 PM
  5. Date Format Display
    By drunkenneo in forum Access
    Replies: 5
    Last Post: 06-20-2013, 07:06 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