Multiple Conditional Formatting in Datasheet View Form

Discussion in 'Microsoft Access Form Coding' started by SAP2, Jan 23, 2008.

  1. SAP2

    SAP2 Guest

    Scenario:
    Access 2003
    Datasheet view form
    Control is a text box- PN
    I have 6 conditions for this text box.

    The 'Select Case' works in the On Format Event in one of my reports but the
    same does not work when putting into the datasheet view form. I have placed
    it in the On Current, On Open, and On Load Events with no change to the back
    color of PN.

    Any suggestions? Thanks in advance.
     
    SAP2, Jan 23, 2008
    #1
    1. Advertisements

  2. SAP2

    . Guest

    dans l'article , SAP2 à
    a écrit le 23/01/08 2:31 :

    > Scenario:
    > Access 2003
    > Datasheet view form
    > Control is a text box- PN
    > I have 6 conditions for this text box.
    >
    > The 'Select Case' works in the On Format Event in one of my reports but the
    > same does not work when putting into the datasheet view form. I have placed
    > it in the On Current, On Open, and On Load Events with no change to the back
    > color of PN.
    >
    > Any suggestions? Thanks in advance.
     
    ., Jan 24, 2008
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Layne

    Form View & Datasheet View on the same form

    Layne, Jul 29, 2004, in forum: Microsoft Access Form Coding
    Replies:
    0
    Views:
    153
    Layne
    Jul 29, 2004
  2. Dan W

    Re: conditional formatting datasheet view

    Dan W, Oct 19, 2004, in forum: Microsoft Access Form Coding
    Replies:
    0
    Views:
    270
    Dan W
    Oct 19, 2004
  3. Guest

    Conditional formatting in a form datasheet view

    Guest, Dec 29, 2004, in forum: Microsoft Access Form Coding
    Replies:
    0
    Views:
    237
    Guest
    Dec 29, 2004
  4. Danielle Haile via AccessMonster.com

    linking Main form in single form view to subform in datasheet view

    Danielle Haile via AccessMonster.com, Apr 1, 2005, in forum: Microsoft Access Form Coding
    Replies:
    1
    Views:
    295
    Rob Oldfield
    Apr 2, 2005
  5. Mike Painter

    Re: One form in datasheet view, one form in regualr form view....

    Mike Painter, Nov 23, 2008, in forum: Microsoft Access Form Coding
    Replies:
    1
    Views:
    275
    Mike Painter
    Nov 26, 2008
Loading...

Share This Page