#Error

[SG]

I have the following set as the control source of a text box
=[subtotal]-[sub total] whihc works fine until there is nothing in the field
and I get #Error how do I stop this?

Thanks in advance

S

 

[Damian S]

Hi SG,

Assuming it's all working fine, seems like you are having NULL problems.
Use the nz() function like this:

=nz([subtotal],0) - nz([sub total], 0)

This will replace a NULL value with a zero.

Damian.

 

[SG]

Damian,

I have tried this but I am still getting the #Error ??

Hi SG,

Assuming it's all working fine, seems like you are having NULL problems.
Use the nz() function like this:

=nz([subtotal],0) - nz([sub total], 0)

This will replace a NULL value with a zero.

Damian.

I have the following set as the control source of a text box
=[subtotal]-[sub total] whihc works fine until there is nothing in the
field
and I get #Error how do I stop this?

Thanks in advance

S

 

[Damian S]

Do you have your control (ie: text box) with the same name as your database
field? This will cause confusion for Access and give you the #Error issue
also.

Damian.

Damian,

I have tried this but I am still getting the #Error ??

Hi SG,

Assuming it's all working fine, seems like you are having NULL problems.
Use the nz() function like this:

=nz([subtotal],0) - nz([sub total], 0)

This will replace a NULL value with a zero.

Damian.

I have the following set as the control source of a text box
=[subtotal]-[sub total] whihc works fine until there is nothing in the
field
and I get #Error how do I stop this?

Thanks in advance

S