auto-size width or Label or Text Box

[jguscs]

Is there a way to have a Label or Text Box auto-size its width to its dynamically-changing contents with VB (like when you double-click it during design mode)?

 

[Rich]

Use the built in zoom box, it's easier

 

[jguscs]

zoom box?
I looked through the ActiveX controls and it isn't listed as one of the standard controls (next to/near the label and text box) as far as I can see.
I'm using Access 2000.

 

[SforSoftware]

Try pressing F2 when the cursor is in a textbox.

In code it is:
DoCmd.RunCommand acCmdZoombox

 

[Autoeng]

Check out the CanGrow property.

 

[Rich]

Check out the CanGrow property.

only works when printing a form

 

[jguscs]

Right, and I read (in the Help file) that it only grows (or shrinks) vertically... I want mine to grow or shrink horizontally.

I just changed the Width property on a case-by-case basis (there are a limited number of phrases that the Label will receive).

 

[Autoeng]

only works when printing a form

You're right Rich. I wasn't paying attention. Should be "only works when printing a report"

 

[Rich]

No, it also works when printing the form