Results 1 to 2 of 2

Thread: Using IIF..????

  1. #1
    Join Date
    Jul 2007
    Location
    Columbia SC
    Posts
    81

    Unanswered: Using IIF..????

    Hey,
    I am trying to use something like this but having #Error message. or sometime Circular Reference error..
    I have a field name Cycledate and In database i do have same name for column...
    =IIf[CycleDate]=#01/01/1900#,"",CycleDate)
    actually What i want to do is to check value of Textbox if it is 1/1/1900 than i should reset its value of "" so that it should be counted as a valid value.. and shouldnt be displayed on the form..

  2. #2
    Join Date
    Jul 2007
    Location
    Columbia SC
    Posts
    81
    alright...just change the name of the field and done..

    Thanks Though..

Posting Permissions

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