Add an asterisk to the front and back of a number

[kiplook]

I've got a table with a five character part number. I would like to add a field that contains that part number with an asterisk at the front and back of the part number.

12345 becomes *12345*

This is to create a barcode for scanning using a Free 3 of 9 font.

Here's the catch - I'm using Access 97 (Don't ask - I'm working on it).

Any help would be appreciated.
Kip

 

[John Big Booty]

Why not simply store the raw number and then add the additional asterisks at the time of printing or display, using something like;

"*" & Me.YourNumberField & "*"

 

[kiplook]

Thanks.
That worked great!