Results 1 to 3 of 3

Form Conditional Formatting during Query

  1. #1
    ry94080 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2019

    Form Conditional Formatting during Query

    Hi all,

    I have form that acts as a display board. Every few minutes it refreshes. The refresh can take up to 10 minutes as there is plenty of data to pull down.

    My issue is that one of the fields is a conditionally formatted field. If the value is 1, it shows a green box, 2 yellow, and 3 red.

    When the refresh takes place and the queries are running. The conditionally formatted field blanks out and waits for all the refresh queries to complete.

    Does anyone have any ideas to display 3 colored boxes based on a value that won't do this during runtime?

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    how efficient are your queries? - 10 mins seems a very long time to display what is presumably a summary.

    not sure if it would work, but perhaps divide your form into 4 or more display forms and refresh one after the other. Total time might be the same but the time to refresh each individual form would be less. You can have a 'background' form and position each (popup) form over it

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    Maybe base the cf on unbound hidden textboxes and only update those when the queries have all finished? Should work even if the unbound control is hidden.
    Something like "Expression Is [text10]="whatever"
    I didn't know what to put for 'whatever' part
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    Sometimes I talk to myself - like when I need expert advice.

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

Similar Threads

  1. Conditional formatting in a crosstab query
    By andy49 in forum Queries
    Replies: 4
    Last Post: 03-15-2018, 02:01 PM
  2. Conditional Formatting on a form
    By AndyC121 in forum Forms
    Replies: 1
    Last Post: 03-23-2017, 09:13 AM
  3. Replies: 6
    Last Post: 08-30-2016, 05:43 AM
  4. Replies: 3
    Last Post: 12-11-2012, 06:27 PM
  5. Conditional formatting on form
    By ngruson in forum Forms
    Replies: 11
    Last Post: 09-17-2010, 12:15 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