adding characters before and after existing text

[leomark]

How can I add a character before and after an existing text-string? I have a field that contains 1001 and when I print it out I would like to change it to *1001* automatically as part of the print script. I tried to use "Set Field" to "*tablename:fieldname*", but all I got as tablename when printing.

So what's the correct way of doing it?

Thanks

[Fitch]

Your calc would look like this:

"*" & yourField & "*"

But why not simply put the asterisks on the layout that you're printing? Using a merge field, perhaps.

[leomark]

Thank you for your very quick response.

That's the calculation I was looking for.