Address util.

[rpbenito]

I'm making a utility for an access 2000 database that prints out a persons name and address on labels. I am having trouble getting a format to get it in this format...


Name
Address
cite,state zip

All the name, address, etc. are fields in a table.. any ideas would be of great help...thanks a lot

 

[SgtJarrow]

If you are using a report that this will be printed from make three text boxes. Bind the first to name, the second to address, and the third set:

=[City] & ", " & [State] & " " & [Zip]

This will make them appear as you have requested. Hope this is what you need "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." Albert Einstein.

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com