Note: You will only see #Error? or #Name? message printed in the report if you first test your report using a human-readable font (e.g. Arial, Times, Courier), otherwise you will miss these errors.
See: The following page in the Access Help, which explains fully these errors;
#Error? or #Name? may appear in a control for a number of reasons. To correct the problem, do the following:
If you are design view, then it is correct to see strange boxes. Correct bar codes only appear when you Print or Print Preview the report.
If you have used Print or Print Preview and you see boxes, here are the possible causes;
Cause: You may have chosen the incorrect font. For each bar code function, there is a font and font size to use. See: Bar code font name and font size to use to discover the font and font size to select.
When you Print or Print Preview a report or form, if;
- you see no bar code printed
- you see a Bar code error message box displayed.
- you see an Access #Error? or #Name? message printed in the report.
- you are prompted Enter Parameter Value.
then there is a mistake in your report. Below are listed the typical causes of each error and the solutions.
Cause: If you get a bar code error message, the error message should be self-explanatory and no bar code is printed. Usually the problem is due to the data, for example, to print a UPC-A bar code your field must contain an 11 digit number (or your expression must return 11 digits). If the bar code function is not passed 11 digits, no bar code can be printed and error message is displayed.
Cause: A field that contains a Null or Empty value will not print a bar code, which is as you would expect. A bar code error message does not occur if the field contains a Null or Empty value.
Something to check: Open your report in the design view, select the Text Box object which is used to print the bar code, choose menu View | Properties, click the Data tab and check that the Control Source expression is correct. Access may have changed the Control Source property, if you previously changed the Name property.
Cause: If you change the Name property of an object in a report, if the object Name was originally the name of a field, then you will find the Control Source has automatically been changed by Access. For example, if the Name was MyField and the Control Source was;
if you changed Name to AnotherName, Access would automatically change the Control Source to;
If AnotherName is not the name of a field, you can replace it with the name of a field.
If Access encounters a name (function, variable or field name) that is not defined, Access will prompt you to enter the value.
Cause: If the name is a bar code function and the function is not found, it is possible our Visual Basic module has not been installed.See: Import our Visual Basic module in to a database.
Cause: It is possible the Control Source property does not start with = (equals sign).
If you get error message, or results which you do not expect, please contact Technical Support and be ready to give details of the function you are using and other information about your report.
Copyright © 2000 CIA (BAR CODES) UK. All rights reserved. Reproduction prohibited.