Auto-resizing fields on focus

[padlock]

Hi everyone,

Problem I'm running into is I need certian fields to auto-resize when they're hovered over (or have focus) so that all the information is viewable, but then resize back to normal afterwards. The forms contain a large amount of information, so the fields have to be smallish most of the time, but certain fields, such as email addresses for example, are hard to work with because you can't see most of the entry.

Any help would be greatly appreciated. Almost done with this Access project, and it's just little details at this point.

-Walter

 

[KenHigg]

I would just use a tab control...

 

[padlock]

The higher ups want it to auto-expand, with all the info on one screen. The main contact sheet is setup in a way that it echoes all the information of the paper copy, in addition to information pulled from other forms in regards to account status, things like that.

 

[Rich]

Use the built in Zoom box
RunCommand acCmdZoomBox

 

[padlock]

I'm going to run that by them, see if it works for them. Biggest issue with that I can see is the field itself actives on a double click to send email, and a single click or get focus goes to that, then it has to be exited before the double click will work. I resolved that just by making the label clickable. Going to see if they like it or not.

Is there any realistic way to have the field itself expand when it gets focus? I know that's what they really want, and I've never had anyone request anything like that before (always just used large enough fields to see the info.)

Thanks for all the help so far.

 

[Wilder]

Resizing revisited

I need to do the same thing and would much rather have the textbox resized as opposed to the zoom box.

Also, I don't want to have to put the code in for each textbox on the form. Is there a way to have the resize (or zoom box) occur for ANY control that has the focus? That is, something like

Screen.ActiveControl.Width = 1440

Actually, this could work if you put it in a public function and then set each control's gotfocus propert to equal the public function. But that's almost as painful as writing the bit of code for each control in vb.

Any ideas???

Doug in Fairbanks