empty field to variable

[Jean-Paul]

Hi,
in my code I have now:
contact = [Forms]![verslagen].[Sub_Bedrijsgegevens].[Form].[Contactpersoon]

Of course I first wrote dim contact as string.

Now:
[Forms]![verslagen].[Sub_Bedrijsgegevens].[Form].[Contactpersoon]
is empty, so I get an errormessage when the code reaches this line
saying something like:
illegal use of Null

How to avoid this and let the code continue even if it meets a null-field

Thanks

 

[Beetle]

Try;

contact =
Nz([Forms]![verslagen].[Sub_Bedrijsgegevens].[Form].[Contactpersoon],"")