Error# if subform blank

DBL

Registered User.

Local time

Today, 14:14

Joined

Feb 20, 2002

Messages

659

• Jun 21, 2002

• #1

I've got a calculation on a main form that is reference to a subform. If the subform is empty I get Error# in the calculation field. Is there anyway to make that field blank if the subform is empty? I've tried the Nz function and that's not working.

 

R

Rich

Guest

• Jun 21, 2002

• #2

You might try the IsNumeric function

 

DBL

Registered User.

Local time

Today, 14:14

Joined

Feb 20, 2002

Messages

659

• Jun 21, 2002

• #3

I haven't managed to find anything on the IsNumeric Function, I must be searching in the wrong place....

 

R

Rich

Guest

• Jun 22, 2002

• #4

I suspect you've got one of the newer versions, from what I read here finding any help is now a challenge, I believe you can talk to XP, but being an MS product it wont take a blind bit of notice, so that option's out.
Try this then
=IIf(IsNumeric([My subform].[Form]![TextBox]),[My subform].[Form]![TextBox],0)

 

DBL

Registered User.

Local time

Today, 14:14

Joined

Feb 20, 2002

Messages

659

• Jun 22, 2002

• #5

Rich, you're a wonder. It's working beautifully - thanks very much.

I can go on my holiday with a clear conscience!

Dawn

 

kingsgambit

Registered User.

Local time

Today, 14:14

Joined

May 27, 2001

Messages

134

• Aug 13, 2003

• #6

Can you change that if it is a subform.
So on my main form if the user does not select a item from the subform the report will show zero.