#error

S

Simon Glencross

Someone has told me this before but I cant remember for the life of me how
to resolve it... How do I stop the #error messages?

Thanks in advance

s
 
J

John Vinson

Someone has told me this before but I cant remember for the life of me how
to resolve it... How do I stop the #error messages?
Click to expand...

By correcting the error in your form or report.

For a more detailed answer please post a more detailed question. Under
what circumstances are you getting #Error, and where?

John W. Vinson[MVP]
 
S

Simon Glencross

I am recieveing this error in a sub form which is in data view on the last
row where I have the following calculation
=CCur(Round([realisedPrice]*1.175,2)) the lines above are fne as it has data
to calculate but the last row has no data entered as yet.
 
J

John Vinson

I am recieveing this error in a sub form which is in data view on the last
row where I have the following calculation
=CCur(Round([realisedPrice]*1.175,2)) the lines above are fne as it has data
to calculate but the last row has no data entered as yet.
Click to expand...

You're getting #Error because the Round() function can't handle a NULL
value. What do you want to see here if there is nothing in
realisedPrice?

I'd suggest checking for a null value with an expression like

=IIf(IsNull([RealisedPrice]), Null,
CCur(Round([realisedPrice]*1.175,2)))


John W. Vinson[MVP]
 
S

Simon Glencross

I'd prefer the field to be blank as there shouldnt be anything in it.....


John Vinson said:
I am recieveing this error in a sub form which is in data view on the last
row where I have the following calculation
=CCur(Round([realisedPrice]*1.175,2)) the lines above are fne as it has
data
to calculate but the last row has no data entered as yet.
Click to expand...

You're getting #Error because the Round() function can't handle a NULL
value. What do you want to see here if there is nothing in
realisedPrice?

I'd suggest checking for a null value with an expression like

=IIf(IsNull([RealisedPrice]), Null,
CCur(Round([realisedPrice]*1.175,2)))


John W. Vinson[MVP]
Click to expand...
 
Top