Frame Titles not Printing in UserForm

**narrowgate88** · 07-08-2010, 04:04 PM

For some reason when the user form prints, it only prints Cens from the first frame title and prints no other frame titles. I don't know how to fix. File is attached.

**Leith Ross** · 07-08-2010, 05:36 PM

Hello narrowgate88,

I tried printing the UserForm on my printer and none of the Frame captions printed. They show up on the screen fine, but do not print. This is first time I have seen this problem.

There are 2 workarounds I can think of. First would be to remove the caption from the Frames and use Labels instead. The other, which is more complicated, would be to create a screenshot of the UserForm (in VBA code) and print that.

**narrowgate88** · 07-09-2010, 09:20 AM

Interesting. Well I'm glad it's not just me. I'll try the label option. I looked around a lot yesterday for a print screen option and it seemed more complicated than I wanted to get. Thanks for your help.

**narrowgate88** · 07-09-2010, 09:28 AM

I tried the label option and it just doesn't look as nice. Is there a way to get the label to lay over the frame as opposed to above or below it? I tried to "bring forward", but I couldnt' set it on top of the frame line.

**Leith Ross** · 07-09-2010, 12:06 PM

Hello narrowgate88,

The problem with using Labels is you can not align them on the Frame in the area where the Frame Caption is displayed. The Frame is a container object (another word for a window). A window has 2 distinct parts: the title bar or non-client area and the general display or client area. Objects may be moved or dragged and dropped only in the client area. This is why the Label can only be underneath or above the frame.

**narrowgate88** · 07-09-2010, 12:23 PM

Well then it's a real bummer that the frame titles are not printing. Thanks for your help. I'm going to leave this open for the rest of the day in case anyone else has had experience with this in the past.