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

D

Damian

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.
 
A

Al Campagna

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

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
 
W

Wayne-I-M

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.
 
W

Wayne-I-M

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.
 
Top