The closest thing I can think of to a list would be to open the code editor
and search help for "form object". The resulting page will have two headers
at the tope called Properties and Methods. These will list all of a form's
properties and methods.
Depending on where the code is, you may be able to use a built-in constant
instead of the number, if one has been defined. If one has been defined it
will be in the help article for that topic. This applies to functions as
well. The built-in constant will be recognized in VBA code, but not in a
query or as an equation in a calculated control. In your example, it could
be written:
Forms(strFormName).BorderStyle = acDialog
However, this constant comes from the DoCmd.OpenForm function call and it
just happens that the value is 3 here also. I don't see a constant for Thin
or Sizeable, but you could create your own. In a standard module, create a
Public Constant that you could use elsewhere in your code.
--
Wayne Morgan
MS Access MVP
<al********@it4us.nl> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
This works fine! I created a form, with a pulldown based on:
SELECT [msysobjects].[Name]
FROM msysobjects
WHERE ((([msysobjects].[Type])=-32768));
and a button with caption "Design the form". Looks nice, works nice.
Now I'd like to improve it and set all desired properties in a table,
so I got better control over it than hard coded. I got two additional
questions:
All the properties I need to translate Dutch->English. I've been
digging on the web, but I can't find a simple list of Form properties.
In the help files it's all scattered information as well. Anyone knows
a good list?
If I want to set certain properties, I need to set a value. Can this
been done simpler?
What I mean is e.g.:
Forms(strFormName).BorderStyle = 3 ' this number is "dialogue"
Thanks for any help.