[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 706
  • Last Modified:

Extended 3 of 9 Barcode font - MS Access code return and tab characters

I have downloaded the Free 3 of 9 Barcode Font Extended.  I am trying to embed tabs into my strings.  However, the $I just prints as part of the string, no tab occurs.
0
andreabyer
Asked:
andreabyer
  • 5
  • 4
3 Solutions
 
DultonCommented:
I am trying to embed tabs into my strings.

I'd use Chr(9) to concatenate a tab into a string.
=MyFirstString.Value & Chr(9) & MySecondstring.Value

A site like this is good to have bookmarked:
http://www.asciitable.com/
0
 
andreabyerAuthor Commented:
It needs to be one string using Extended 3 of 9 font.  I have read that the control characters can be embedded, $I = tab; $M = Enter, but the control characters simply print, no tabbing or carriage return.  *ABC$Iabc* (in 3 of 9 ) =  ABC$Iabc (scan value).
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
It's your scanner.  Most need to be configured to read extended 3 of 9.  If it's not, you'll get what your getting.

Jim.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
andreabyerAuthor Commented:
I scanned the Symbol code for enable code39 Full ASCII.  I am able to read lower case, symbols, but I cannot seem to get it to read the $M, $I as LF and HT.  It reads literally - in my barcode, it scans as $M and $I
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Hum....well nothing wrong with what your doing as far as the bar code itself that I can see.  But in regards to lower case, you should be needing to use a +<letter> to get that.

Since your coding this:

*ABC$Iabc*

and getting:

ABC$Iabc

 I don't think your scanner is really setup for extended 3 of 9.  You should be having to encode it as:

 *ABC$I+A+B+C*

 to get

ABC     abc

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Instead of letters and non-visible characters, try:

*%K%J%M*

That should result in:

 [?]

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Another thought:  look at the driver settings for the scanner.  

Quite often the driver will over ride what a scanner sees, especially when it comes to tab, returns, etc.

Jim.
0
 
andreabyerAuthor Commented:
Thanks for all the suggestions!!  I will give it another whirl tomorrow.  I am getting the lower case letters, the forward and backward slash, just not the CR or HT.  I didn't think about checking the drivers.  I am using an old symbol scanner, scanned the Enable Full ASCII barcode from manual, at least my lower case letters are proper now.
0
 
andreabyerAuthor Commented:
%K%J%M = %K%J%M
0
 
andreabyerAuthor Commented:
I ended up downloaded the Extended 3 of 9 barcode font.  I also scan the barcode to enable Full Ascii
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now