formatting a null value

Results 1 to 2 of 2

Thread: formatting a null value

  1. #1
    Join Date
    Dec 1969

    Default formatting a null value

    i have formatted a field to 1 decimal place but sometimes when the field is null i get an error message saying: Type mismatch: &#039;FormatNumber&#039;. here is an example of my code <BR>&#060;%=FormatNumber((Ethnic.Fields.Item("AvgO fMaths").Value), 1, -2, -2, -2) %&#062;<BR><BR>can u help me write (if null leave blank) statement please.<BR>many thanks <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: formatting a null value

    If Not IsNull(Ethnic("AvgOfMaths") Then<BR> blah...<BR>End If<BR><BR><BR><BR>- jørn

Posting Permissions

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