Spell Check a Report Form

[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

 

[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

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.

 

[bw]

Wonderful! Thanks Fred!
Bernie

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.