Results 1 to 3 of 3
  1. #1
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615

    Conditional formatting problem - formatting not initially displayed

    I have form, used as a subform, which has conditional formatting defined for one field. The form is displayed in datasheet view.



    The problem is that when the data is initially displayed, the conditional formatting is not applied - in order to see the conditional formatting, I have to scroll through all the records with the cursor in that field (just moving to the record isn't enough - it has to be that field).

    Needless to say, that is not very useful when users need to see any potential problems with the data as soon as the form is opened; I can't expect them to be scrolling on a specific field all the time.

    As I recall, this was not a problem prior to Access 2010 - earlier versions were OK.

    Does anyone know of a way to apply the conditional formatting when the data is first displayed?

    I tried me.repaint - no luck
    The problem is still there if I open the subform by itself as a regular form.

    Thanks

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    I have not experienced this symptom, but I would try changing the subform's Recordset Type to Snapshot. Of course, you will not be able to apply updates to a snapshot, only a Dynaset.

  3. #3
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    When you said you had not experienced this symptom, it got me to thinking maybe it's my own PC and not MS Access at all.

    That turned out to be the case - I tried the same database on two other machines, and it performed as it should, so there must be something not working on my PC.

    Marking as solved - thanks.

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

Similar Threads

  1. Conditional Formatting
    By Thompyt in forum Programming
    Replies: 6
    Last Post: 04-01-2015, 01:53 PM
  2. Replies: 6
    Last Post: 05-26-2013, 09:10 PM
  3. Conditional Formatting Problem
    By baileysw in forum Access
    Replies: 2
    Last Post: 11-21-2012, 06:23 PM
  4. Conditional Formatting vs. VBA Formatting
    By gopherking in forum Reports
    Replies: 5
    Last Post: 11-09-2011, 06:53 PM
  5. Conditional Formatting Problem
    By DanKoz in forum Access
    Replies: 6
    Last Post: 10-23-2011, 12:57 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