Spell Check a Report Form

B

bw

I have a form with an unbound control, which is used to pass information to
an unbound control on a report. The form is activated by the Report On Open
event.
Is there a way to "automatically" spell check this control (and any others
that may be on the form) before passing the information to the report?

Thanks,
Bernie
 
F

fredg

I have a form with an unbound control, which is used to pass information to
an unbound control on a report. The form is activated by the Report On Open
event.
Is there a way to "automatically" spell check this control (and any others
that may be on the form) before passing the information to the report?

Thanks,
Bernie
Click to expand...


I assume the Report opened this form in acDialog.

Code the click event of a Command Button on the form

DoCmd.RunCommand acCmdSpelling
Me.Visible = False

Remember to close the form in the Report's Close event.
 
B

bw

Wonderful! Thanks Fred!
Bernie


fredg said:
I assume the Report opened this form in acDialog.

Code the click event of a Command Button on the form

DoCmd.RunCommand acCmdSpelling
Me.Visible = False

Remember to close the form in the Report's Close event.
Click to expand...
 
Top