Modifying a Text Field

[johnp51merlin]

I have a text field that is defined as a Personell Property Number which
looks like the following: 341010000128400002. I need to insert hyphens and
periods so it looks like this 34-101-0000-1284-00.0002

 

[John Spencer (MVP)]

Use the format function

Format([Personel Property Number],"@@-@@@-@@@@-@@@@-@@.@@@@")

You MIGHT need to put a reverse slash in front of the dashes and periods. I
don't think that is the case though as long as this field is a text field.
Also, your example number is not long enough to fill all the slots. If that is
a typo, then the format above should work, if it isn't then you will have to do
some more work to get the value you want.