access 2010

Paul,

<<1) when I click on report view it gives me and extra page on my report. But, it is suppose to only show 1 page of report and I dont know why it shows two pages?>>

  Usually this is because you have a report that is larger then the page size less margins.  Often this is a result of leaving the right edge of the report off to the right.  So first, open the report in design view, and drage the right edge of the report over to the left as far as you can.  Then check the ruler.  If your still larger then page size less margins, then your need to change something (size of detail section, the margins, or the page size).

<<2) I concatenated two fields on my report on and set their font to barcode and almost tried every barcode for I had but non of them were scanable by my barcode scanner. This is suppose to be a label for barcdoe scanning and the size needs to be 4*6.>>

  Have you worked with Bar Codeing before?  Bar Codes are much more then simply a font.  Bar Codes often require guard characters, check digit's, and sometimes specific spacing to be scanable.  Simply putting data in a control and using a bar code font will not work.

JimD.

Can you please refer to the attachment I uploaded. I need to change the font on the barcode option that is on my Report. As I mentioned I'm a beginner and trying to learn. So, can you tell me what am I missing in my access file in the report to make it scan-able by the scanner:
 

I attached my access file in the question.

Thanks,
Paul

can you please assign my question to access zone?

Experts, I need some help here.

Thanks.
Paul

Paul,

<<Can you please refer to the attachment I uploaded. I need to change the font on the barcode option that is on my Report. As I mentioned I'm a beginner and trying to learn. So, can you tell me what am I missing in my access file in the report to make it scan-able by the scanner:>>

 Looks like your trying to use Code 3 of 9.

  Change your control source to:

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

Jim.

I used ="*" & [Customer Code] & [Job Number] & "*" and it worked. Would this be fine to use?

Thanks,
Paul

thanks