Field size increase in table is not reflected in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I needed more characters (50 up to 90) in one table field, but the report is
generated by a series of queries run by a macro....and does not reflect the
increase in field size. What do I have to do to each query so the report
will display this field with all the characters?
 
You should not have to do anything to modify a query (unless it is using
"right" "left" or "mid" to only pull a certain number of characters).

A report, though, is normally a finite size for each control added. You
would need to modify the design of your report to make the fields wider.

Rick B
 
Hi, Rick.. Thanks for your reply. I realized I was dumping the query results
to a slave table to assemble the data. That was where the characters were
trimmed.
Thank you for being out there, friend.
 
Back
Top