Useing Bar Codes In a Report

[Ron Corbin]

I am trying to print a report in Access that includes a type 39 alpha
neumaeric Bar Code. I have downloaded a 39 Bar Code Font that works well in
Word Pad but not Word. I have set the Text Box Control Source of my Report as:

=("*" & [Customer Name - Address]![Customer Number] & "*")

Where Customer Name - Address is the Table and Customer Number is the field
containing the data I want in the bar code.

When I run the report I get an message box asking for the Customer Name -
Address. I just say OK without putting in data and the report shows on
screen in print preview. It looks just like I expect it to except that I can
not read the Bar Code.

I have looked into useing an Active X to print the Bar Codes but I can not
get authorizarion to spend the $400 it would take.

Any and all help appreciated

 

[Rick Brandt]

I am trying to print a report in Access that includes a type 39 alpha
neumaeric Bar Code. I have downloaded a 39 Bar Code Font that works
well in Word Pad but not Word. I have set the Text Box Control Source
of my Report as:

=("*" & [Customer Name - Address]![Customer Number] & "*")

Is your report bound to the table [Customer Name - Address]? If so then all
you should need is...

= "*" & [Customer Number] & "*"

If your report is not bound to the table [Customer Name - Address] then you
need to be aware that you cannot pull values from tables using a syntax like
that. You would either add the [Customer Name - Address] table to the
report's query (joined as appropriate to existing tables) so you can refer
to the [Customer Number] field or else use a DLookup() function to retrieve
it.