Results 1 to 7 of 7
  1. #1
    ry94080 is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2019
    Posts
    32

    OnFormat event in Forms?


    What would be the equivalent of OnFormat (Reports), but on Forms?

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,450
    There isn’t as far as I know - the facilities for printing forms is much more limited than printing reports

    what is it you are trying to achieve?

  3. #3
    ry94080 is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2019
    Posts
    32
    I have a form that we are using as a "display screen" to show real-time updates
    I am currently using Conditional formatting on the form which works. However, it doesn't work while the form is requerying from our IS system, which could take a few minutes.
    It only works when the form is not querying / processing.
    I was hoping i could create 3 text boxes with 3 colored background (green,yellow,red) and perhaps have them be "visible" based on a value. But, wasn't sure what event to attach that to.
    Any ideas are appreciated

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,450
    Ok - so same question as your other thread which I have responded to.

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    5,012

  6. #6
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,450
    crosspost is suggesting the same things I did in the OP's other post. What a waste of time, Don't know why I bother

  7. #7
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    5,012
    Quote Originally Posted by CJ_London View Post
    crosspost is suggesting the same things I did in the OP's other post. What a waste of time, Don't know why I bother
    Yes, not like the O/P is a newbie either. Joined UA 2005 ?, even here in 2019.
    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

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

Similar Threads

  1. SetProperty for OnFormat in Report
    By Nico80000 in forum Macros
    Replies: 5
    Last Post: 04-29-2021, 01:24 PM
  2. Replies: 6
    Last Post: 05-08-2019, 03:25 PM
  3. run-time errror '13 on forms on open event
    By sdel_nevo in forum Programming
    Replies: 12
    Last Post: 01-20-2016, 09:25 AM
  4. Continuous Forms After Update Event
    By Perceptus in forum Forms
    Replies: 6
    Last Post: 09-24-2015, 02:19 PM
  5. Report load events - OnFormat???
    By weasel7711 in forum Reports
    Replies: 1
    Last Post: 04-20-2011, 09:33 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
  •  
Other Forums: Microsoft Office Forums