How do I change an existing form's properties?

[dc1688]

Hi, I need help on how to change an existing form's properties while running VB codes. I need to be able to manipulate the form's size because it is subject to change depending on the data in the tables. Thanks in advance. Really appreciate the help.

 

[rewdee]

To change the form's size of an existing form, you will need to be in designview. The way I have done it in code was something like:

dim frm as Form
set frm=Forms!MyForm

with frm
  docmd.open .name,,,acHidden
  .width=ANumber
  .height=AnotherNumber
end with

Docmd.close acform,.name,acsave
set frm=nothing
docmd.open acform,Forms!MyForm

I don't know if this is the best way, but accept for the annoying flickering, it works well.

Hope this Helps,
Rewdee