Avatar of peispud
peispud
Flag for Canada asked on

Calculate width of printed text in mm (if possible)

Hi

I am using Microsoft Access.  I am using a SDK to print directly to a Brother labeller  (one of 3 templates)

In this case, the label will only have one field.   My code will populate that field.

In order for my app to choose the appropriate  label template,  I must first calculate the printed width of my data and then choose the appropriate template.

So, how do I calculate the width of that printed text in mm (if possible) ?

ps.  I know that  many of you are helping others,  just because..       I hope your good Karma comes back to you and your loved ones in these difficult times.
Microsoft Access

Avatar of undefined
Last Comment
peispud

8/22/2022 - Mon
John Tsioumpris

Maybe there isn't a Windows label template that matches your label.
Just measure your label (your provider should have supplied the exact dimensions but just in case)
Go to Control Panel --> Devices and Printers -->JUST Single Click one of your Printers -->"Print Server Properties" should become visible on the top --> Create a New Form --> Enter the exact dimensions of your label....BEFORE you enter the numbers consult your Brother labeller...it probably has an empty space (margin/gap whatever ...it would be some mms) ...enter this to the "Printer Area margins"..give your label a name.
Now head to Access...open your report...page setup...select the Brother...select the label (the name YOU gave)...now just tweak the report to match the label dimensions...just keep getting it shorter/narrower till the green overprint indicator turns off
ASKER CERTIFIED SOLUTION
Arana (G.P.)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
peispud

ASKER
Thank you for your help.  

The question was correctly answered,  Thank you.


But my question should have been

Is it possible to make the printed label size changeable depending on the text length?


The FAQ shown below was exactly what I was looking for.  There the question is answered.

https://www.brother.co.jp/eng/dev/bpac/faq/index.aspx
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23