Barcode Font (1 Viewer)

A

andymac

Registered User.

Local time

Today, 02:47

Joined

Jun 2, 2013

Messages

36

• Jun 9, 2013

• #1

Greetings,

I am using a barcode font in order to generate a number as a barcode on my report records. In order for my barcode scanner to read the barcode it needs an asterisk at the beginning and at the end.

So, if my record ID is 62 - in order for the barcode to be displayed correctly, it needs to be on the report as *62* .

Without digressing into a discussion on barcode methods in Access, how can I precede and succeed each ID number field with an asterisks?

Trust I make sense,

Andy

 

RuralGuy

AWF VIP

Local time

Yesterday, 19:47

Joined

Jul 2, 2005

Messages

13,826

• Jun 9, 2013

• #2

With concatenation. "*" & [RecordID] & "*"

 

A

andymac

Registered User.

Local time

Today, 02:47

Joined

Jun 2, 2013

Messages

36

• Jun 9, 2013

• #3

Hi, thanks for the reply,

I'm getting this:

syntax error in query question '["*" & [ID] & "*"]'

Any thoughts?

A.

 

S

shadow9449

Registered User.

Local time

Yesterday, 21:47

Joined

Mar 5, 2004

Messages

1,037

• Jun 9, 2013

• #4

Get rid of the outer brackets...

SHADOW

 

RuralGuy

AWF VIP

Local time

Yesterday, 19:47

Joined

Jul 2, 2005

Messages

13,826

• Jun 9, 2013

• #5

Shadow9449 is correct. Show us the complete statement you have.