October 5, 2015 at 5:42 am
Hello ,
I have a problem to display in access barcode for this string: 123456-01
In excell it works fine, but in access appears an error.
I think that problem is with "-" in string.
Control source is: =("!" & [string] & "!")
Could you give me a hint how to display this string without error?
thx.
October 5, 2015 at 5:55 am
Rather than using =("!" & [string] & "!") for your control source, I would use =("*" & [string] & "*") as that is the normal start and stop delimiter - see Code 39 - Wikipedia. I'm surprised the expression you used in Excel actually works based on the ANSI standard.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 5, 2015 at 6:02 am
Yes both works fine in excell but not in access.... string 123456/01 is displayed in access okay, but 123456-01 NOT.
October 5, 2015 at 6:09 am
What version of Access (and of Excel) are you using? And have you tried using the * as the start and stop character per the standard?
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
October 5, 2015 at 6:14 am
access 2007,excel 2007 , yes I have tried it, but always the same.
October 5, 2015 at 6:16 am
but I think that problem is with special character minus "-" between numbers 123456-01... maybe I need to convert the string ...I dont know..
October 5, 2015 at 6:31 am
right now I found that other colums with minus is displayed corectly...it is strange... although both columns are set nvarchar.
October 5, 2015 at 6:41 am
ok done, I just created copy of the field I wanted to have for barcode, set font, and source as before.
Fortunately everything works.
October 5, 2015 at 8:11 am
I suspect the "minus" sign you were using wasn't the standard one but a special character with a different ASCII code. Often it is the simple little things that give us the most grief. :w00t:
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply