Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    139

    Unanswered: macro expression - Not Null

    I am trying to put together a macro expression that would run the macro if two fields were not null. I wrote this but the program says the function is no good.

    IsNotNull([QTYREC] And [LOCIDREC])

    If this was positive, the macro would run.

    Any suggestions are appreciated.

    Thanks,
    B&R

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I think you might want to use:

    Not IsNull([QTYREC]) And Not IsNull([LOCIDREC]).

    You can also try:

    Len([QTYREC]) > 0 And Len([LOCIDREC]) > 0.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •