how do I use an Input Mask to add extra caracters to sequence

[Guest]

i am trying to change the following sequence of caracters obtained from an
underlying query to include a * at either end. I need to do this within a
report only as this will then be used to generate a barcode.

 

[Al Campagna]

Damian,
Create a claculated field (ex. txtYourTextField) on the report...
= "*" & [YourTextField] & "*"

 

[Ed Robichaud]

You need to FORMAT the values displayed in your report; an input mask
controls data entry (typically in forms) only on new records.

Try: Format('*'+[myField]+'*')

-Ed

 

[Guest]

Hi

Set this is the control source of the field in the report

="*" & [QueryFieldName] & "*"

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.

 

[Guest]

ooops. just noticed I gave the same answer as Al Campagna, just ignor my
answer.

Sorry - the other answers didn't show up at 1st.


--
Wayne
Manchester, England.
Enjoy whatever it is you do
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.