Blank fill not exporting for all fields - Access to Word

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

Guest

I have an Access report which I analyze with MS Word. All of the field have
a specific number of space they must occupy, and the data has differend
lengths. For example: the first field must occupy 5 spaces, the second
field 10 spaces, the third 15 spaces:
xyz 123456789 abcdef
I put an input mask in the report to blank fill the unused space by putting
##### in the Input Mast property of the 1st field, ########## in the Input
Mast property of the 2nd field, and 15 # signs in the Input Mask property of
the 3rd field.
When I analyze the report with MS Word, only the blank spaces for the 2nd
field are there. The other two fields did not blank fill. I do not know how
to correct this. Any suggestions how to resolve this.
Further, when I have a field which does not get populated with data, I need
this field to be the number of blank spaces to fill the field, and these do
not work.
 
Input masks are used, well, for input. You don't "input" into a report.
Have you tried using a query and coercing the fields to strings of the
proper length using the CStr() function?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top