number value display

[sharkey_lsu]

Hi,



I have a question regarding the display of a list of numbers that are stored into a field of my database. Currently the numbers are comma-delineated which is fine with me, but I was wondering if there is a way to change the display of those numbers on the form so that it is easier to read.
Example:

current format - 1,2,3,4,7,8,9,10
desired format - 1-4, 7-10

Any help would be greatly appreciated.

Thanks!!

[June7]

This would require rather complicated custom VBA function.

[orange]

sharkey,

It might help readers if you described WHAT you are trying to accomplish. As June7 says it would/could involve a custom function. There may be other ways/options to get what you want if we knew the underlying issue.

Also, having multiple values in a field could be part of your issue. Microsoft has made multivalued fields possible, but most people avoid this construct.