Access form missing fields at printout

[DaveBo]

I have a form in an MS Access project file (.adp) that has a subform on a tab control. On screen it looks fine, but when I send it to the printer the textboxes and checkboxes on the subform are cleared (screen doesn't change),
and one of the textboxes has a calculation built-in that gets biffed and reports "#error" because it's trying to calc from 2 of the textboxes that were cleared during printing.

I don't know if this makes any sense, but, the bottom line is apparently that a copy of the form is somehow being built for sending to the printer.

Any ideas?

Alternatively, I can capture the screen to the clipboard, but how can I send the clipboard to the printer from within VBA?

Thanks, DaveBo

[DaveBo]

I've tried reenacting the crime from scratch.

Totally new Access DB file
Form1 with nothing but a Textbox on it - saved
Form2 with nothing but Form1 as a subform - saved

I open the form, type some numbers into the textbox and print the form.
On the printout ... the textbox is empty!?!

Where are my numbers going?
Is this a bug in Access?

Thanks, DaveBo - hyperflabberghasted

[Hack]

How are you printing the form?

[DaveBo]

Printing the form as:
- While the form is displayed and active
- File - Print ...

The Print Preview shows the data there fine, it just won't print.

I just added another textbox to the main form, i.e. not on the subform.
The data typed into that prints fine.

Thanks, DaveBo

[DaveBo]

Maybe this should be telling me something, but, a workaround I've just found is

when I load the textbox values in VBA if I simultaneously load the defaultvalue
then it prints fine.
e.g.
Text4.Value = 1234
Text4.DefaultValue = 1234

Note, CheckBoxes are doing the same thing.

Have fun, DaveBo