PDA

View Full Version : userform.print problem



av8tordude
01-19-2011, 09:58 AM
Can anyone tell me why my frame captions are not printing when using userform.print

CaptRon
01-20-2011, 08:08 PM
On your userform, be sure the visible property for the frame is set to true. If its false, it won't appear in print or on screen.

Ron

av8tordude
01-21-2011, 08:34 AM
Ron, Thank you for your response, but that was my first instinct to check. Unfortunately, it still doesn't print the captions

CaptRon
01-21-2011, 10:18 AM
Ron, Thank you for your response, but that was my first instinct to check. Unfortunately, it still doesn't print the captions

Can you see the frame itself and just the caption is missing? If so, check the ForeColor property. If its set as button face (&H8000000F&) the frame can be seen but the caption will be invisible. Just a thought.

Ron

av8tordude
01-21-2011, 10:23 AM
the forecolor is &H80000012&. still not printing.

I found a work-around solution by copying and pasting the form on a sheet. Not an option I would choose first, but I guess I have to use this option until I find a better solution. Thanks for your help