Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010
    Posts
    67

    Unanswered: How do I code a IF statement that calls a function in the CONTROL SOURCE property?

    Hello,

    I would like to call a function in the control source property of a continuous form, ONLY if the control(i.e.field) on the continuous form is NOT NULL.

    Is this possible?

    What would the syntax/code look like?

    Thanks in advance!!!

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183

    How do I code a IF statement that calls a function in the CONTROL SOURCE property?

    You cannot validate the same Field from where you call the Function from, if not then you can try this.

    Code:
    Field1    Field2
                =IIF(ISNULL([field1]),0,myFunction())
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Posting Permissions

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