Neat and tidy 2 column value lists

[E Gish]

I have not been in the forums for a while now... sorry all. So I have a lot of catching up to do.

I did not find this in a quick search, so if it has already been answered maybe I can be pointed in the right direction

I have a value list which displays 2 fields side by side. I want to be able to put field A with a spacing between field B... giving the appearance of a tabbed 2nd field so everything aligns nicely.

Currently the 2nd field is butted up against the 1st field with only a single space between it giving a very ragged look to the value lists.

Microsoft Access gives the ability to display a 2nd field by a given width. Why can we not do that with FM?

Any help is greatly appreciated. Thank you

[Reed]

Why not create a calculated field that looks like two columns as the second field in the list. In FM8 you can set it to only show the second field.

The display field would just be a concatenation of the two fields you want displayed, along with a variable number of spaces between them depending on the length of the first field...

The way I used to deal with this when you had to show the ID value in a value list along with the other value, was to make all my ID serial fields text, and pad them with zeros on the left:

0001

0002

0003

...

9999

Then the second column lined up nicely.

I don't do this anymore though, since you don't have to display ID values...