How can my memo/text box expand so i can read the whole thing? access 2007

[yepwingtim]

Thanks You~

Edit: In a form where I'm reading the result not when I'm printing
________
Subaru Impreza Wrx Sti Specifications

 

[gemma-the-husky]

have another form, with a large text box with scroll bars, bound to the same recordset and just containing that memo field

open this form at the correct record.

Note - if you want to edit the expanded memo, you will need to save the record before opening this popup, as otherwise the record will be dirty, and you will get the

"another user etc " message


----------
sorry

make the text field on the base form, locked and not enabled so yuo can't interract with it - but put a transparent command button OVER it - and open the popup form in response to clicking the transparent button - YOU CAN CLICK A TRANSPARENT BUTTON

 

[missinglinq]

<Shift> + <F2> will zoom the current control to a larger size.

Or if that's beyond your users (all users are not created equal) you can use the Double-Click event of the memo field:

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

 

[gemma-the-husky]

linq

i never knew that

That's amazing!

 

[yepwingtim]

is there a way using a arrange method button to show all everything?

I need to see it on the fly basically... Can't open another form etc.

Thanks
________
VAPORIZER HELP

 

[missinglinq]

You know, Dave, that's the reason I enjoy Access so much; there are always more things to learn!

is there a way using a arrange method button to show all everything?

I'm sorry, yepwingtim, but I have absolutely no idea of what you're trying to say here! Is an arrange method button something new in Access 2007?