Should Appear Blank

[gatsby]

Hello everyone,

im having a problem about my DBS. there is a calculation in the Query then amount or total will appear in the Form. there are some items that doesnt have information in the Table, so obviously calculation wont be involve in that specific item. now, if theres no information to be calculated unbound box SHOULD be blank BUT in every items that doesnt involve a calculation it appear this error ----> #Type!

i want to eliminate that one and make the unbound box to appear blank instead of #Type!

because people might think that is really an error when in fact it will just appear because no calculation took place.

Thanks!

[burrina]

How about a If IsNull statement or using Nz in your code?

[June7]

Post the query SQL statement. Simple arithmetic calculation with null should result in null.

[gatsby]

I placed that code in the Query's criteria:

=IsNull([Total Cost])

But still it gives me #Type!

in the Form, I placed this --> =CLng(Nz([Total Cost].[column](21),0))

please correct me if im wrong. Thanks.

[June7]

That IsNull expression should return just True or False regardless of value of [Total Cost].

Why would you put that expression in criteria? What are you trying to do?

That error is due to datatype mismatch. You have a combobox with 20 or more columns?

If you want to provide db for analysis, follow instructions at bottom of my post.

[gatsby]

its edited and heres what i replaced:

Total Cost: Nz([Base Cost],"")+Nz([Contingency Amount],"")

so far, its giving me 0 (zero) value not #Type!

[June7]

Is that good? Issue resolved?

[gatsby]

i guess so, i will settle with 0 (zero) for now than having #Type! message in an unbound box.

Thanks.