You're welcome, Jane.
And, yeah, Access is fat with alternative approaches.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jane
Sent: Thursday, August 30, 2012 1:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Spell check a combo box
Thanks Bill - Good idea, I'll give it a go - always more than one way to skin a
cat, eh!?
Jane
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@...>
wrote:
>
> Jane
>
> That's a tricky one. What about putting the combo behind the text box so that
the dropdown arrow shows. Make the text box the bound control and use the
combo's AfterUpdate event to put the selected combo value in the textbox for
editing.
>
> If you need more specific instruction give us the names of the two controls
and one of us can write up the code for the event for you.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Jane" <jcross@> wrote:
> >
> > I have several forms, each with several combo boxes on them with memo fields
as the source.
> > They are combo boxes as the contents usually start as 1-2 standard sentences
and then the user adds extra details. The users now want the memo fields to
spell check, but I've found that combo boxes can't be spell checked. I've played
around with copying the contents of each combo box in turn to a invisible text
box, but then I have problems when the user corrects typos using the spell
check.
> >
> > Any suggestions, gratefully accepted.
> > Jane
> >
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar