Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Space character in Code 39

Space character in Code 39

Space character in Code 39

I am a barcode novice trying to get a code 39 font to work in an Access Report.  Everything seems to be working OK, except I can't read any barcode that contains a space character (there is a blank gap in the printed barcode).  The report pulls from a large existing database that contains space characters in many data items.  Is there any code 39 type font that solves this problem, or perhaps some way to modify the raw data in the the Access query?

RE: Space character in Code 39

Windows will not let anyone create a character in the blank space area.
So I substituted a Code 39 barcode space for an underscore.
You need a function that will change all the spaces to an underscore for the barcode.
This does not affect the regular data in anyway.
The barcode when scanned will show a space.
The underscore character in our font is a code39 space.
Does that make any sense?

Now this only works in our Barcode font.  So you have to buy a new one.

DougP, MCP

RE: Space character in Code 39

Anyone know of a font you can buy that would work with a space character, or alternatively how I can use some type of formula in Access to convert the spaces in the raw data to another character?

RE: Space character in Code 39

If you put in *999_99*
will this show up as 999 99  ?
If so I have tried this and hav not had it work!

RE: Space character in Code 39

In Morovia Code39 fonts you can use = to get the space. Having barcode pattern to spaces could bring many problems, and most of barcode font vendors choose other symbols in the place of space.


RE: Space character in Code 39

Our Code 39 font came with our software package.  I have called the software's tech support and they tell me, "The standard code 3 of 9 font, as provided, does not allow for a space in a single barcode"

I'm confused becuase I thought a space was part of the Standard Code 39 Font

Could someone explain how this works?  I have tried %A...%Z, $A...$Z and /A.../Z and still no spaces.



RE: Space character in Code 39

Call the company you bought it from and ask then all are different.

DougP, MCP, A+

RE: Space character in Code 39

The original Code 39 character set consists of bar code symbols representing characters 0-9, A-Z, the space character and the following symbols:  - , . , $ , / , + , %.

The Extended or Full ASCII extension to the original Code 39 uses a pair of characters to represent the other ASCII characters. For example an underscore is supported as $O.  So CONN_ATT may be bar-coded as *CONN%OATT*, but this only works if the scanner is configured to accept Extended Code 39 bar codes.

Usually I have a problem where I don't properly delimit fields and so I get a bunch of leading spaces barcoded, which just adds unnecessary length to the barcode.

See http://www.adams1.com/pub/russadam/39code.html for details and some links.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close