How do I fix the #type!

[Shortone]

Yep- I'm a total newbie to access and don't have a DB background.

Since converting to Office 2010, I get #type! instead of a $ amount when I print.


Any ideas?

[ajetrumpet]

what are you printing? a report? what does it say when you view it? same thing? (I hope!)

what code is attached to the control that's throwing the error?

[Shortone]

Hi Adam,

In the print preview- i get the #type! displayed. In the design view I have a variety of different control sources such as
="(" & [ac] & ") " & Format([phone],"#-0000") which in previous version would show the clients phone number.

I didn't set up the report (and haven't got a clue how to) but since upgrading I have quite a few different text boxes showing #type!

Any ideas you have would be greatly appreciated!

Shona.

[ajetrumpet]

i'm not real sure. i've never seen this one before. this article explains the causes for the other errors closely related: http://support.microsoft.com/kb/90860

I would guess, if the db is not corrupted, that you can find the answer by using bits and pieces of the whole value, a little at a time. e.g. - first try:

="(" & [ac]

if that displays fine, add more to it. etc, etc...until the error is thrown.

if the first parenthesis ends up throwing the error, something is corrupt. the rpt, the db, the control. something.