• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

Converting Pixels To Centimetres


Has anyone ever used ABarCode 2000 software to create barcodes in reports?

The problem I am experiencing is that I am unable to change the visibility of this barcode because of the way ABarCode uses the textbox.

I have been told that i should reference the barcode control from a new textbox control and then set the visibility options of this control.

However, when I reference the barcode control in a new textbox I only get the text value displayed and not the barcode.

Does anyone know how I can get the barcode to display?

1 Solution
this is reposted from:

>How do I change the Access options to use pixels as opposed to centimetres...
>or how do I use cms in VBA?
not quite sure what you mean. but instead of setting the visible property to true, how about setting
the width property to 0 (or 1 if 0 isn't allowed). is this the idea you're going for when you want to
deal in centimeters?

access works with what they call twips. for some (insert deity) forsaken reason, 1 twip is = to 1/1440
inches. that's a little obsene if you ask me. but 1440 IS divisible by 2, 3, 4, 6, 12, 16, ... so maybe
it made sense to some silly american.

here's an excerpt from A97 help file:

Unit of measurement used by Microsoft Access that is equal to 1/20 of a point, or 1/1440 of an inch.
There are 567 twips in a centimeter."

the problem is that when you're using forms/reports you need to convert everything into twips from inches/centemeters.

hope this helps. if not, just let us know.

I don't know about the barcode stuff, but there isn't a conversion from pixels to cm.  Pixels are the number of dots on a bitmap display.  The size of 20px will vary depending on the size of the monitor you are using and the resolution of the display or printer.

I'm not silly, but there is a reason for the size of a twip.  In fact dovholuk posted the reason, it's a discrete fraction of a point.  Look at EM's EN's, picas, points, leading and you'll be in the world of printing, where these sizes all came from.

Twips were probably the smallest fraction of a point that could be reliably displayed on monitors.
a discrete fraction yes, but it's still a "silly" discrete fraction. 1/20th? 1/10 i could understand, 1/25th, 1/50th etc. 1/20th just seems arbitrary.

The asker hasn't logged in since July. Points to dovholuk if no response from asker.

community support moderator
Per recommendation, force-accepted by
CS Moderator
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now