Quote Originally Posted by Hack
No, no, no. Lets think about this for a second.

How is the address stored? Is it three strings that you are concantinating:

1234 Main St.
Our Town, MI
480000

or is it a continuous string like 1234 Main St. OurTown, MI 480000

What is causing the bulk of the problem? The street address? The City/State?
Well ok let me take a minute and explain my program to you a bit. It is a scheduling program and these are some of the fields I have. FName, LName, Address (Which is the full street address, no city or state or zip) Then I have Year, Make, Model (of the vehicle)

What is happening is some FName, LNames, or Addresses are eaither longer or shorter then others so the spacing is really ugly. Something like this:

Chris Lawson 970-xxx-xxxxx
1234 S Lemay St
1994 Honda Civic

then the next will look like this:

Christopher Lawson 970-xxx-xxxx
1234 N Lemay St
2004 Chevy Freightlin <--- (Would cut the end of this vechile off)


So I'm justing looking for a way to have these fields grow and hopfully shrink depending on the information.

Thanks a ton!