MS Access - Alter rectangle width using Macro - Contractor UK Bulletin Board

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

thunderlizard replied

19 June 2007, 11:24
Ooh go on then. I was bored yesterday and was going to have a go for you for old times sake, but realised I don't actually have Access installed. Was it anything to do with Repaint not being strong enough to actually refresh the shapes from metadata?
Leave a comment:
Orangutan replied

19 June 2007, 10:46
Its ok, I've sorted it - if anyone is interested in the solution, let me know
Leave a comment:
Orangutan started a topic MS Access - Alter rectangle width using Macro

18 June 2007, 10:52
MS Access - Alter rectangle width using Macro

I am trying to alter the width of a rectangle on a form from a Macro.
I can reduce the width to zero easily by using .....
SetValue, [Forms]![progress bar]![rectProgressBar].[Width]=n
then RepaintObject, but no matter what value I put as n, the rectangle is almost non-existant.
I know a little about twips (567 to the cm apparently), and even setting n to large numbers (above 567) seems to make no difference.

I'm sure its something simple thats I'm doing wrong.
Tags: None