Autosize Memo Field [Access 2003] 1

[Maillme]

Hi There,

Isitpossible to auto size a memo field on my form - which is individual to each form?

If not, at least to the biggest "chunk of text" within my records.....

many thanks,
Neil

 

[Remou]

What do you wish to achieve? It may suit to make the memo field quite small and prompt users to use Shift+F2 to zoom, or add a little code to the doubleclick event to zoom.

 

[Maillme]

Hi there,

What im trying to achieve is not have any text missing on the box at first site.

E.g. - have them use the scroll bars - i dont anticipate it being huge, but they may miss important info,

many thanks,
Neil

 

[Remou]

That could get quite complicated. Not only will you need to resize the control, you will need to resize the form. The limit will be the size of the screen, so it may be best just to make the memo as large as the form will take.

 

[Maillme]

yea - i think ill maybe look at more of an "education" appraoch to using the shift F2 button!

thanks again for your help.
Neil

 

[ProgramError]

I agree with Remou. If the information is that important, you should show all of it, otherwise use zoom.

routine for zooming using the click event is...

Private Sub textboxname_Click()
  DoCmd.RunCommand acCmdZoomBox
End Sub

Ian Mayor (UK)
Program Error
Always make your words short and sweet. Because you never know when you may have to eat them.

 

[Remou]

I find that using the click event for anything just irritates users, so I always suggest double-click.

 

[ProgramError]

the click event has its uses but I agree double would be better in this case to prevent inadvertently opening the zoom.


Ian Mayor (UK)
Program Error
Your lack of planning is not my emergency!

 

[Maillme]

Many thanks people,
Neil