Barcoding in Access

[TKT_BEER]

Hi everybody! need help on the following...
I have a string of numbers.. 74103-250-03 I need these numbers to appear in a report as barcode.. I do have the barcode font but this barcode font needs an asterisk on the beggining and ending of the string.. like so: *74103-250-03* for the scanner to read them correctly.

Question I have is: What do I need to do so the asterisks get added to the field automatically? this would be in done on a report and not a form.

 

[SydneyGeek]

Let's say your barcode string is called BarString. In the query that underlies the report, build this calculated field:
MyBarcode:="*"&[BarString]&"*"
Use MyBarcode where you need the barcode to appear in the report.

Denis

 

[kskinne]

also, check the operating manual that came with your barcode scanner - i have a symbol cobra scanner that can be programmed such that it will add a character or keystroke(s) before and/or after the barcode that is scanned


hth
kevin

 

[TKT_BEER]

thx guys my application is running as I intented...