Claus,

Changing font size has no effect - it still truncates the last 6 characters
of the second string at font size 6, 7, 8, etc...



On Tuesday, April 3, 2018 at 9:13:38 AM UTC-4, Claus Busch wrote:
Hi,

Am Tue, 3 Apr 2018 05:46:17 -0700 (PDT) schrieb :

Tried your suggestion. The result is the last character of the Proprietary2
string is truncated.

reduce the font size to 7


Regards
Claus B.
--
Windows10
Office 2016

Just following Claus' suggestion about font size, I set up a sheet as follows:

LeftHeader: &[Date]
CenterHeader: "This string length is exactly 48 characters long" & vbLf
& "The second line string length is much longer at 70 text characters long"

The total length is 120 characters;
The default font Calibri Regular 8pt is used;
Screen res is 1920x1080 at 125% DPI;
Paper orientation is Landscape;
PrintPreview shows the entire footer content.

I suspect your header will print as expected, but your screen res won't show
that if the page is shrunk to fit your screen.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion