Form properties

[Lou_Reed]

I am building a form with the following properties:



Name
BackColor
Caption
Height
ScaleMode
Width
The VBA code was originally written in an early version of MS Access. I am using MS Access 2010. These are all form properties and I have a couple of questions.

Are all of these properties in the MS Access 2010 version?

When I put in Width a 8250 it responds that number is too large; likewise when I put in Height at 6015. What is wrong?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[CJ_London]

Scalemode is not and never has been a form property (it is a property for certain report controls). Nor for that matter is backcolor or height. These relate to a form section (header/footer/detail), not the form.

how are you putting in a width? in properties you use cm or inches depending on your setting. in vba you use twips (1440 twips=1 inch)

[Lou_Reed]

The link for the program is here:

http://www.informit.com/articles/art...30837&seqNum=6

That should answer the questions. I just started on and took it as form properties.
It sure looks that way. The title says:

"set the form's properties to the values listed here:"

I understand that height and width can be in cm or inches, but twips?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[CJ_London]

you link is for vb, not vba

this will tell you all you need to know about twips

https://support.microsoft.com/en-us/...tch--and-twips

[Lou_Reed]

I did not know that there was that much of a difference between VBA and VB. I mean they are both Microsoft products.

This says for properties, that is unmistakable for MS Access VBA. Is it not?

Respectfully,

Lou Reed

[CJ_London]

why to you think that? The title of the link is clearly

Programming Card Games with Visual Basic

VB and VBA are similar, but not the same. Often you can use code snippets from one in the other or at least translate them to work in a different environment. VB uses (or can use) winforms (not access forms) and is usually developed in visual studio.

The fact they are both Microsoft products is immaterial. Ford makes cars, van and trucks - would you expect their maintenance to be the same?