Date Format 30.12.1899

Comments

• gordk St.Catherines On. Canada.

  December 2004 edited 11:38PM

  generally in the obp event of the band check the datafield using the fieldisnull function provided and turn visibility of the memo on or off
  or in the memo itself use a complex if function checking the datafield for null in the expression portion and returning '' or 'some text' in true value param and the '[tblname."fieldname"]' in the false value param
  beware of the field is null function when [tblname."fieldname"] is placed in it, it must be in the form of and if built using the expression builder these extra apostrophes will not be present.