Interrogate the new entry in a field

[mbentley]

My users have requested that I provide a popup textbox that gives them more room to enter text than can be provided in the smaller parent field in my form. I made a simple popup form that has one unbound field that allows text entry. When the user double clicks in the parent text field, the popup opens populated with the contents of the parent field. Once they close the popup, it overwrites the parent field with the entry in the unbound textbox. It all works fine, except for one thing. If the user enters some text and then double clicks the field, it populates the popup with the old value, not the new value. If I enter some text, click out of the field, and then double click it (without saving the record), it then populates the popup with the dirty data. Wierd. It's as thought the change to the field is not registered until you leave it. If I add a line of code that sets the focus to the active field (which seems redundant), the problem is solved, but this is a hackneyed workaround, and I'm curious to know the underlying cause. Any thoughts?

 

[Rich]

Why not just use the built in Zoom control?

 

[dgm]

Zoom control?

Maybe it's like u say,it's not saving the record while it still has the focus? I think that's how access works...

Try a docmd.RunCommand acCmdSaveRecord before opening the popup?

 

[Rich]

DoCmd.RunCommand acCmdZoomBox

 

[dgm]

ohhhhhhhh

Now that could come in handy!

thanks

 

[Rich]

SHIFT + F2 also opens it

 

[mbentley]

Duh

I obviously have special access keys disabled, so I assumed that the SHIFT+F2 would not work. But it does. Guess we all know what happens when we assume.
Thanks.

 

[Rich]

You're welcome, has the Snow started falling in the hills yet?

 

[mbentley]

On second thought...

I was just playing with the zoom function. Althought it's simple to implement, it doesn't leave you with much control or custimizability over the user's input. So I'll stick with my own method. Looks like there are advantages to doing it both ways.

And yes, we're under a foot of snow here.