Scheduler expand text box question

Try this... you cant 'expand the textbox to the left', but you can move it left before expanding it.

Private Sub t1_GotFocus()  -----------Got Focus
FW = t1.Width
FL = t1.Left
FH = t1.Height
Me.t1.left = Me.t1.Left - 5000
Me.t1.Width = 5000

Me!t1.Height = 3000
End Sub

Select allOpen in new window

Private Sub t1_LostFocus()  ----------Lost Focus
Me.t1.Width = FW
Me.t1.Left = FL
Me!t1.Height = FH
End Sub

Select allOpen in new window

Slight modification to what mbizup posted so that the right side of the textbox stays in place.

Private Sub t1_GotFocus()  '-----------Got Focus
    FW = t1.Width
    FH = t1.Height
    FL = t1.Left
    Me.t1.Width = 5000
    Me!t1.Height = 3000
    Me.t1.Left = FL - (Me.t1.Width - FW)
End Sub

Select allOpen in new window

Looks like Miriam already corrected herself.
:-)

:-)

I figured having the textbox visibly scooting around the screen would drive the users to distraction.

Maybe it will seem like a game.  Much better if you move the textbox around when the mouse approaches.
;-)

irogsinta

Than you for that Advice was going to change to call a function

chestera

mbizup

Thank you for that

chestera

chestera,

Glad to help out.


Ron,
https://www.experts-exchange.com/questions/27981629/Access-Experts-General-discussion-thread-for-Access-Zone-31-Dec-2012.html?anchorAnswerId=38769424#a38769424

Miriam,
I want to see what you did but I only have 2007.  
:-(

Ron,

I've updated my comment with it in .mdb format.

Thanks Miriam,
I'll check it tonight when I get home. I'm up in Richmond for my son's gymnastic competition.

Woot! Have fun with that.

It sounds like we might be neighbors.

IrogSinta

Hope this is not out of order it now works fine right hand of the screen going right to left. I have now been trying to figure out how to change from Top to Bottom to bottom to Top. This is for the the last text box's at the bottom of the screen

regards
Alan

mbizup

I have 31 box's on the screen representing the 31/30 days of the month (28 for Feb) they are quite small (Enough to put a heading for the reminder) when the user click on a day that box it expands to a large size so user can read/Add text. the field in the tbl is a memo field so thwer is no restriction on the amount of text ie 255 characters. Would you expand the box as the mouse movers over the box rather than click on the box

Thank you for your comment

Alan

Responding, borrowing Ron's code because I'm right here...

Something like this:

Private Sub ExpandMe(ExpandUp as Boolean, expandLeft As Boolean)
    Dim ctl As Control
   
    Set ctl = Me.ActiveControl
    FW = ctl.Width
    FH = ctl.Height
    FL = ctl.Left
    FT = ctl.Top
    ctl.Width = 5000
    ctl.Height = 3000
    If expandLeft Then ctl.Left = FL - (Me.t1.Width - FW)
     If expandUp Then ctl.Top = FT   - (Me.t1.Height - FT)
End Sub

Honestly, I would not bother with the expansions.

Have you tried Access's built-in ZoomBox feature?

Click on a control and hit Shift-F2 if memory serves me right.

I noticed a mistake in my code. Just change this part as well.
  If expandLeft Then ctl.Left = FL - (ctl.Width - FW)
  If expandUp Then ctl.Top = FT   - (ctl.Height - FH)

Something I have done in my own databases with similar issues (such as continuous forms with limited space with textboxes bound to memo fields) is to add this to the double-click event of any memo fields:

Docmd.runcommand accmdZoomBox

Select allOpen in new window

and simply instruct the users to double click the textbox if they want to enter text or see all the data in the field.

mbizup

Many thanks for your help most appreciated. Re using the expansion I am using access 2003 so assume you are talking about 2010.

Alan

IrogSinta

Thank you again most appreciated

Alan

IrogSinta

Sorry to trouble you again. Not quite sure about the If statement
If expandLeft and the If expandUp should there be a value in variable  the expandleft and up

Alan

Chestera,

I was actually not specifically referring to 2010.  The zoom box and that code should work in 2003

mbizup

Ok thank you. Didn't know it existed

Alan

Chestera,
Here's what it should look like:

Private Sub ExpandMe(Optional expandUp as Boolean, Optional expandLeft As Boolean)
    Dim ctl As Control
    
    Set ctl = Me.ActiveControl
    FW = ctl.Width
    FH = ctl.Height
    FL = ctl.Left
    FT = ctl.Top
    ctl.Width = 5000
    ctl.Height = 3000
    If expandLeft Then ctl.Left = FL - (ctl.Width - FW)
    If expandUp Then ctl.Top = FT - (ctl.Height - FH)
End Sub

Private Sub ShrinkMe()
    Dim ctl As Control
    
    Set ctl = Me.ActiveControl
    ctl.Width = FW
    ctl.Height = FH
    ctl.Left = FL
    ctl.Top = FT
End Sub

Select allOpen in new window

Most of your controls should use
Controls on the right should use
Controls on the bottom should use
The control on the bottom right that needs to expand left and up should use:

Miriam,
You did have time on your hands.  Cool beans!
 :-)

mbizup

Yep it worked Shift F2. Learn something new every day

Alan

IrogSinta

Yep got that.  Many thanks again. You went above and beyond the question much appreciated.

Alan

-->> Learn something new every day

Ain't it great?

The database I use that in is a Discrepancy Report Database with a mainform/subform setup.  The mainform shows the main trouble report; the subform displays all of the actions taken towards resolving the problem.  The users wanted to see the actions as a list... so that they could quickly see and enter information such as date, stats and description.  The description field however could be huge... and to keep it looking okay in a continuous subform, we could only display a small portion of the text.

So that zoombox was perfect, with the double-click event code "DoCmd.RunCommand acCmdZoomBox" (which is the VBA equivalent of Shift F2)

mbizup

Thank you for all your help all the best
Alan