Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Resize text box moves current record off screen 1

Status
Not open for further replies.

NorthNone

Programmer
Jan 27, 2003
445
US
When a text field receives the focus in my form, it automatically expands to show all the text in it. But then the record is out of sight - if you scroll down the now expanded detail section of the form you can see it, but I want the form to automatically show this record without the user doing anything.
Then when the text field loses focus, it returns to its shorter condition, and I want to still be on that record.
Am having a brain cramp on this one. Help gratefully received.

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.
 
I have had a similar problem in the past. To fix it I get the index of the selected record, refresh the screen, then reset the focus back to that record. Something like this;
intTrace = (Me.Form.CurrentRecord)
Call Form_Load
DoCmd.GoToRecord , , acGoTo, intTrace

hope this helps!
 
YES!!!!!!
That did it.
Thanks and a STAR!!!
Have a great Memorial Day Weekend :)

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top