Expand field through doubleclick

I have a textfield that can contain 254 characters. Since I have little room
on my form I kept it about 10 characters wide. How and what do I do so that,
when a user doubleclicks this item, he/she can see all the info entered?
I.e. that the field expands to the whole 254 characters size?

TIA Access Dummie Henro

On Thu, 20 Nov 2003 22:21:26 +0100, "Henro V"
<maxlesallaud@hotmail.com> wrote:
[color=blue]
>I have a textfield that can contain 254 characters. Since I have little room
>on my form I kept it about 10 characters wide. How and what do I do so that,
>when a user doubleclicks this item, he/she can see all the info entered?
>I.e. that the field expands to the whole 254 characters size?
>[/color]
This will open a zoom box and allow the user to see all of the
characters.

Private Sub txtMyTextBox_DblClick(Cancel As Integer)
DoCmd.RunCommand acCmdZoomBox
End Sub


- Jim

Perfect Solution, Thank You!

"Jim Allensworth" <jimNOT@Notdatacentricsolutions.com> wrote in message
news:3fbd3ff6.278551687@news.west.earthlink.net...[color=blue]
> On Thu, 20 Nov 2003 22:21:26 +0100, "Henro V"
> <maxlesallaud@hotmail.com> wrote:
>[color=green]
> >I have a textfield that can contain 254 characters. Since I have little[/color][/color]
room[color=blue][color=green]
> >on my form I kept it about 10 characters wide. How and what do I do so[/color][/color]
that,[color=blue][color=green]
> >when a user doubleclicks this item, he/she can see all the info entered?
> >I.e. that the field expands to the whole 254 characters size?
> >[/color]
> This will open a zoom box and allow the user to see all of the
> characters.
>
> Private Sub txtMyTextBox_DblClick(Cancel As Integer)
> DoCmd.RunCommand acCmdZoomBox
> End Sub
>
>
> - Jim
>[/color]