Odd Error Message

[Shelba]

Has anybody had an error message as follows when trying to view a report:
"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data".......obviously, I'm not trying to paste anything!

 

[llkhoutx]

You probably have a large text field that your inserting into a smaller text field.

Or some other data type conflict between data sources.

 

[Shelba]

The report has been working fine for years. recently changed VAT field in query to:
IIf([exclude VAT]=false,(Sum([SELL]*0.175)),("0.0")). The query runs fine ....just not the report

 

[Atomic Shrimp]

Funny, I had exactly this problem today on a database that has been in constant operation for more than a year and contains over 500,000 records; none of the fields I was appending was too large for the table (Access wouldn't tell me which one it was, so to debug, I made multiple copies of the query, in each one deleted all but one of the append columns, each one worked OK)

In the end, I rebooted the machine and it worked OK; I think it was actually all tied up with a problem on our network (I can't prove this, but the query worked fine after a reboot, and the file server was reporting locking problems with the PC that the query was running on)

Don't know if this is any help...

Mike

 

[Shelba]

hi mike, I managed to find the problem by using a similar method as you did....It now appears that the problem is DEFINATELY the VAT text box on the report(detailed above), but Im confused as to why this works fine when the query is run. re-boot no good either

 

[BigJimSlade]

This is an old posting, but I thought I would add to it since I rarely ever get to throw in my 2 cents...

I had the same problem, and I foudn that deleting the query and rebuilding it from scratch (or using copy/paste) allowed the query to work properly.

Big Jim