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. Steven M. Britton

    Datasheet view VS. Form View.

    Steven M. Britton, Jul 7, 2003, in forum: Microsoft Access Form Coding
    Replies:
    1
    Views:
    822
    Dan Artuso
    Jul 7, 2003
  2. Layne

    Form View & Datasheet View on the same form

    Layne, Jul 29, 2004, in forum: Microsoft Access Form Coding
    Replies:
    0
    Views:
    265
    Layne
    Jul 29, 2004
  3. Guest

    How can I go from access datasheet view to the form view

    Guest, Dec 2, 2004, in forum: Microsoft Access Form Coding
    Replies:
    1
    Views:
    265
    Rick B
    Dec 2, 2004
  4. Guest

    Conditional formatting in a form datasheet view

    Guest, Dec 29, 2004, in forum: Microsoft Access Form Coding
    Replies:
    0
    Views:
    295
    Guest
    Dec 29, 2004
  5. Guest

    Shading alternatie rows in datasheet view and in form view?

    Guest, Feb 9, 2005, in forum: Microsoft Access Form Coding
    Replies:
    4
    Views:
    497
    Guest
    Feb 9, 2005
  6. 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:
    397
    Rob Oldfield
    Apr 2, 2005
  7. Guest
    Replies:
    5
    Views:
    623
    Duane Hookom
    Apr 20, 2006
  8. 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:
    404
    Mike Painter
    Nov 26, 2008
Loading...