By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,805 Members | 1,202 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,805 IT Pros & Developers. It's quick & easy.

Setting form properties in VBA: do I need numbers?

P: n/a
Hi,
I'd like to set form properties in VBA.
You can set e.g.
Forms("frmDemo").BorderStyle = 3
but how can you set
Forms("frmDemo").BorderStyle = "Dialog"

If so, does anyone know of a useful reference list of the properties
with all possible values?

thx in advance

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
<al********@it4us.nl> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
Hi,
I'd like to set form properties in VBA.
You can set e.g.
Forms("frmDemo").BorderStyle = 3
but how can you set
Forms("frmDemo").BorderStyle = "Dialog"
Er, they're the same thing aren't they?
If so, does anyone know of a useful reference list of the properties
with all possible values?


It's under BorderStyle in the help.

Or if you look at the object browser in the VBA IDE, then find the constant
you want and F1 you'll get the possible values.

Cheers, Mike
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.