Spell Check a Report Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bw - 30 Nov 2005 13:34 GMT

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

Reply to this Message

fredg - 30 Nov 2005 16:59 GMT

> 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
[quoted text clipped - 4 lines]
> 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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

bw - 30 Nov 2005 18:57 GMT

Wonderful! Thanks Fred!
Bernie

>> I have a form with an unbound control, which is used to pass information
>> to
[quoted text clipped - 16 lines]
>
> Remember to close the form in the Report's Close event.

Reply to this Message