Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    angybab is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2020
    Posts
    35
    Hi,



    is it possible to add colours to rows in queries?
    for example I created a query like this:

    CodeNew: IIF(Len([Code])=3;[Code];" " & [Code])
    I want Len([Code])= 3 to be coloured/ or highlighted blue

    so that I can set this to be the row source for the combobox

    is this possible at all.

    since the above solutions didn't help me. I am tring this way.

  2. #17
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by angybab View Post
    is it possible to add colours to rows in queries?
    You can shade alternate rows in queries.
    You can also do limited formatting of columns (query fields) - see my link in post #3

    However you cannot shade each row of a query differently.
    In any case, there is absolutely no reason to ever do this as end users should NEVER interact directly with table or queries.

    Even if it were possible only limited formatting of comboboxes is possible (see same link)
    Sorry but it really isn't worth you (or anyone else) spending further time on this
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #18
    DittoBird's Avatar
    DittoBird is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Apr 2015
    Location
    Newfoundland & Labrador, Canada
    Posts
    59
    Quote Originally Posted by accesstos View Post
    Hi everybody!

    I often use simple forms as useful lists and I have to say that is not as hard as it seems to make a form to simulate a drop-down list, but, I think it demands more work to replace it completely.

    I attach a sample project, with two combo boxes in a main form that use the same hidden pop-up form as drop-down list and I think that the results is close to the desired. <snip>
    This is really nice, John, thank you. Saved for future reference.
    --
    Tim

  4. #19
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    is it possible to add colours to rows in queries?
    for example I created a query like this:

    CodeNew: IIF(Len([Code])=3;[Code];" " & [Code])
    I want Len([Code])= 3 to be coloured/ or highlighted blue
    not sure a) why you want to do this in a query and b) why you want to display part of the vba formula in blue since it would not show when the query is run, but on the basis of what you actually want to display is code in blue if it 3 chars long you could investigate using rich text. - See this link for some ideas on how to apply it https://www.access-programmers.co.uk/forums/threads/how-to-find-richtext-codes-for-highlight-underline-etc.290820/

    But if that is the case, much better and easier to use a form and conditional formatting - in which case perhaps revisit accessto's suggestion

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

Similar Threads

  1. Replies: 3
    Last Post: 08-13-2020, 02:47 PM
  2. ComboBox List
    By Daisy509th in forum Forms
    Replies: 19
    Last Post: 03-22-2018, 07:13 PM
  3. Update Combobox List from another value
    By Joakim N in forum Access
    Replies: 7
    Last Post: 10-12-2016, 11:19 AM
  4. Conditional FontBold based on other control
    By abusaif in forum Access
    Replies: 1
    Last Post: 07-28-2016, 05:27 AM
  5. Change Combobox list after use it
    By TesZero in forum Programming
    Replies: 4
    Last Post: 07-22-2014, 02:14 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