> I hope someone can help...

> I want to try to delete blank spaces from a record in Access 2000.  I
> wanted to try to do it during the data-entry.  So I want to use the
> AfterUpdate function to delete the blanks.  For example:

> in Form1 someone types "abc def" into Contro1.
> I would like to use AfterUpdate to change it to "abcdef"
> Private Sub Control1_AfterUpdate()
>   new.value = Old.value without " "
> End Sub

> I don't know if this is possible.  I'm rather new at this.  Any help
> would be greatly appreciated.

> Using Access 2000
> Code the After Update event:

> [Control1] = Replace([Control1]," ","")

> --
> Fred

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

> > I hope someone can help...

> > I want to try to delete blank spaces from a record in Access 2000.  I
> > wanted to try to do it during the data-entry.  So I want to use the
> > AfterUpdate function to delete the blanks.  For example:

> > in Form1 someone types "abc def" into Contro1.
> > I would like to use AfterUpdate to change it to "abcdef"
> > Private Sub Control1_AfterUpdate()
> >   new.value = Old.value without " "
> > End Sub

> > I don't know if this is possible.  I'm rather new at this.  Any help
> > would be greatly appreciated.

> Fredg, I would have thought the After Update event to be too late, as
> the data is by then saved.  Wouldn't the Before Update event be more
> appropriate in this case, perhaps?

>-----Original Message-----
>I hope someone can help...

>I want to try to delete blank spaces from a record in
Access 2000.  I
>wanted to try to do it during the data-entry.  So I want
to use the
>AfterUpdate function to delete the blanks.  For example:

>in Form1 someone types "abc def" into Contro1.
>I would like to use AfterUpdate to change it to "abcdef"
>Private Sub Control1_AfterUpdate()
>  new.value = Old.value without " "
>End Sub

>I don't know if this is possible.  I'm rather new at
this.  Any help
>would be greatly appreciated.
>.

> hi
> use this:
> Private Sub Text1_AfterUpdate()
> Text2 = Replace(Text1, " ", "")
> End Sub

> this will replace all spaces in text1 with zero lengths,
> giving you the result you wanted. (i hope)
> Erez.

> >-----Original Message-----
> >I hope someone can help...

> >I want to try to delete blank spaces from a record in
>  Access 2000.  I
> >wanted to try to do it during the data-entry.  So I want
>  to use the
> >AfterUpdate function to delete the blanks.  For example:

> >in Form1 someone types "abc def" into Contro1.
> >I would like to use AfterUpdate to change it to "abcdef"
> >Private Sub Control1_AfterUpdate()
> >  new.value = Old.value without " "
> >End Sub

> >I don't know if this is possible.  I'm rather new at
>  this.  Any help
> >would be greatly appreciated.
> >.

> Hi Hugh

> > Fredg, I would have thought the After Update event to be too late, as
> > the data is by then saved.  Wouldn't the Before Update event be more
> > appropriate in this case, perhaps?

> Unfortunately you can't change the data in a bound control in BeforeUpdate.
> Seems crazy, but that's the way it is.

> AfterUpdate for the control happens before the record is saved anyway.

> --
> Cheers!
> Graham Mandeno [Access MVP]
> Auckland, New Zealand

> Return mail address is invalid in a vain attempt to reduce spam.

> Please post new questions or followups to newsgroup.