Toggle control has Null value

[EddyLLC]

In Access2003 I have a form with three toggle buttons. I run an if then on them to determine which is activated. The problem is if I don't select a toggle the value is null and I get an invalid use of null error.

What did I miss? Thanks.

 

[jrbarnett]

Set a default value for the underlying field of 0, and the required property to true. This way, they will never have a null value in them.

An alternative way is to adapt your code to handle null values:

If IsNull (fieldname) Or Fieldname = 0 Then
  ' handle blank data
Else
  ' handle non blank data
End If

John

 

[TheAceMan1]

How are ya EddyLLC . . .

Have a look at the [blue][blue]Nz[/blue][/blue] function ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]