Nifty Access Guy
- Local time
- Today, 16:52
- Jul 9, 2003
Unfortunately I've got 64-bit, and it doesn't work for me with the "Value" .... I've got a couple of other things to try.
I'm using MS Access 2016 on a 64-bit machine, and the code works fine. Initially it didn't. I discovered that because I use "Option Explicit" by default the line of code starting with "Result" failed because "Result" is undefined.
However, I commented out "Option Explicit" and the code starting with "Result" worked OK.
'Result = Barcode_39(Barcode, Me) 'This works IF you comment out Option Explicit
However I would recommend replacing "Result" with "Call" as below, as this works with or without Option Explicit
Call Barcode_39(Barcode, Me) 'This works Either way
I tried "Barcode" both ways, with and without ".Value" both worked..
'Set handle on control.
'Barcode = Ctrl.Value
Barcode = Ctrl
If you have a look at this help article:- Report.Line method (Access) from Microsoft Access, MS demonstrate how to display a rectangular box in red in a Report. This also works OK for me.
I would suggest you set this up by way of a test. This Test might help you locate the problem.