I have a value list that is populated based on two fields, one is the customer code and the other is the customer name. The problem is some customer codes are 4 numbers, some are 4 then a hyphen then 2 numbers. This creates a messy looking list:

For example:

1234-10 St Mary's Hospital

5555 St Thomas

8765-22 St Victory Hospital

2233 Walter Reed

My value list is based on two fields from the customer table. I would like to see the columns even so whether the customer code is 4 digits or seven it takes up the same amount of room.What the quickest and easiest way to achieve this result. Do I have to create a calculation field that masks the client code, then choose that field for my value list? This seems to be a simple thing but I need a push in the right direction.

Thanks in advance!

Caroline

Why are the customer codes hyphenated in this way? Are the first four digits simply a unique identifier and the additional digits some sort of attribute code? For example:

1234 = St. Mary's Hospital

10 = St Mary's Hospital specializes in treating burns

If this is the case, unless the person using the value list needs these codes, I'd stick with just the unique identifier.

Or is there some other reason why the customer codes have this format?