Check for null value in a form field

[RDS2]

I have a form with a bound OLE object field on it. The object is created (an Excel worksheet) with a double click event attached to a command button on the form. What I need is a method to cancel (or at least get a confirmation that this is what the user wants) the re-creation of the worksheet in cases where one already exists.

I've tried something similar to:

IF me.Controls.Item("OLEBound25") IS NOT NULL Then....

This code bombs when run.

 

[mhartman1]

Hello

You want to use the ISNULL function to do this. For instance,

IF ISNull(txtMyTextBoxControl) THEN BEEP.
'
The complement of this would be:

IF NOT(ISNULL(txtMyTextBoxControl)) THEN BEEP
'
Search online help for more information

Regards
Mark