How do I right justify an exported field in access 2003

J

Jason Bennett

I need to right justify a couple of fields in my record when I export it to a
fixed length text file. I hope there is an easy answer!
Thanks!

-Jason
 
J

John Nurick

Use calculated fields in a query. Examples:

Text: Right(Space(30) & [TextField], 30)
Number: Format([NumberField], "00000000.00")

On Thu, 26 Jan 2006 16:31:02 -0800, "Jason Bennett" <Jason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the right style field in VBA 0
Template with fields and premade texts.. 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Autonumber field in Excel that behaves the same as Access 0
How to Create an S-Curve from Custom Field? 0
Copy previous record into form field 0
How to right justify text in a listbox column. 4
How can I justify text my existing paragraph? 1

Top