A2010 Zoom % error "Isn't available now"

JudithARyan
JudithARyan used Ask the Experts™
on
When I try to use the acCmdZoom150 in A2010, I get an "Isn't available now" error.  I get the same error when I try acCmdFitToWindow.  Is this a missing reference or something else?

I'm converting from A2003 to A2010.

Judith
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Are you doing this in a Report or elsewhere ?

I think those commands only apply to Reports ... or possible the Print Preview of a Form.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
^Agree with above, ...also, please be specific when you say:
"I try to use the acCmdZoom150 in A2010"
Use for what object?
Use it on what event?
...and please post the full code, perhaps you have the syntax wrong.

JeffCoachman
JudithARyanTech Support

Author

Commented:
I'm doing this in the OnClick event for a memo field in a form.   In A2003, I used acCmdZoomBox, but I would like to make the zoom area larger for easier typing and reading.

Judith
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

JudithARyanTech Support

Author

Commented:
The event code is just one line:

DoCmd.RunCommand acCmdZoom150
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Then the Object Zoom command is not what you want.


try code like this, it works fine for me on a button in a form:

Me.YourMemoControl.SetFocus
DoCmd.RunCommand acCmdZoomBox
MIS Liason
Most Valuable Expert 2012
Commented:
In other words, acCmdZoom150 will zoom "Objects (reports mostly), ...not controls.

Then best you can do is to create a separate popup form to zoom the memo field.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Won't work in a Text Box ...
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007
Commented:
You can only use the Zoom Box in a Text box :-(
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Like so:
Database54.accdb
JudithARyanTech Support

Author

Commented:
I setting the Solution to A, even thought you guys didn't give me good news.  At least I know where I stand in this situation.

Thanks,  Judith
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
My last post was a technique to do this...
http://www.experts-exchange.com/questions/28693671/A2010-Zoom-error-Isn%27t-available-now.html#a40860191
...did you investigate it?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial