Adding field in query design view to enter 207 blanks.

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

Guest

Hi:
Working on a make-table query to make a table to send to IRS to report
1099's. Many required fields contain various number of blanks. That's easy
when the field is supposed to contain 2 or 10 blanks: " " or " ".
But when it gets to 207 blanks, isn't there some way to indicate blanks
without typing the in individually?
I seem to remember in old Dartmouth Basic you could enter "blanks(207)" in
the code. That doesn't work in designing a query (in design view).
Very glad for any suggestions.
Cheers,
Gus
 
Dear John:
Thanks so very much! Of course, I couldn't see the 207 spaces in Datasheet
view, but String(207,"m") put in the character m 207 times, and I could see
that. So thanks very much again.
Now, I'm always asked to "Read and rate the response." I've searched for a
way to "rate" but no joy. I will click on the "yes, this answered my
question" button, but if there's another way to "rate" I don't know what it
is.
In any case, you have my gratitude.
Cheers,
Gus
 
Back
Top