Re: proper text field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: blackcat (blackcat_at_discussions.microsoft.com)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 07:35:06 -0800

got it ! was trying to call the procedue and module by the same same. works
fine now. thanks for your help

"Jeff Boyce" wrote:

> Create a procedure in the AfterUpdate event of the textbox.
>
> Add something like:
>
> Call ConvertToProper()
>
> As another approach, consider running an update query against the table,
> using the StrConv() function. By the way, "proper" case has some problems
> you may need to clean up by hand. For example, what is the proper
> capitalization of the following:
>
> jones
> jones-smith
> MCDONALD
> VAN DAMME
> vanderwigge
> obrien
> o'brien
>
> ?!
>
> --
> Good luck
>
> Jeff Boyce
> <Access MVP>
> "blackcat" <blackcat@discussions.microsoft.com> wrote in message
> news:3B12D299-ED60-4440-8D09-3215C03CD69C@microsoft.com...
> > thanks, i have found that, tell you to create a module using the following
> >
> > Public Sub ConvertToProper()
> > 'Test if control contains text
> > If IsNull(Screen.ActiveControl) = False Then
> > 'convert text to Proper Case
> > Screen.ActiveControl = StrConv(Screen.ActiveControl, vbProperCase)
> > End If
> > End Sub
> >
> > but now i can't attach the module to the after update event of the text
> box.
> > any idea's
> >
> >
> >
> > "Jeff Boyce" wrote:
> >
> > > Check the StrConv() function.
> > >
> > > --
> > > Good luck
> > >
> > > Jeff Boyce
> > > <Access MVP>
> > >
> > > "blackcat" <blackcat@discussions.microsoft.com> wrote in message
> > > news:20D2CCB6-DFA5-4EE3-8ADD-3A62194CC738@microsoft.com...
> > > > how do i create a poper text field, i have tried entering PROPER(text)
> in
> > > the
> > > > format properties but this doesn't work
> > >
> > >
>
>

Relevant Pages

  • Re: Month Number in VBA
    ... You could perform an update query on your table once you create the field, ... "Jeff Boyce" wrote: ... able to compare project accounting info against other projects, ... I figured the best way to do this was through VBA, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Reverse True/False
    ... "Jeff Boyce" wrote: ... You can do an update query that turns the current value of the field into ... the Not, reversing the Yes/No value. ... Microsoft Office/Access MVP ...
    (microsoft.public.access.queries)
  • Re: Importing from one table to another within the same database
    ... i actually got the update query to work for me pretty much the way i wanted ... the products from the main table and feed in only the seriel numbers in the ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.externaldata)
  • Re: Update current record information to a separate record status
    ... you are pointing out the disadvantages of going that route. ... If I use an Update Query in Access, how does the Update Query know that I ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.forms)
  • Re: Importing from one table to another within the same database
    ... Microsoft Office/Access MVP ... of the fields for the records based on seriel numbers alone, ... update query, it erases all the records entered from form B since those ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.externaldata)