Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 649
  • 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

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