Change a Text or Combo Box under prog control

Ray C · External Since: Jul 15, 2006 Posts: 96

I thought that I knew this but I must be wrong, please help.
I want to change various parameters of text / combo boxes and Labels under
prog control. The Form is called "Main" and i have tried the following to try
and change the parameters of a combo box called "cmb_Hdr_Select1" :-

Private Sub Form_Activate()

With Forms.Main.cmb_Hdr_Select1
.Left = 5
.Top = 2
.Width = 4.5
.Height = 1
.Visible = True

End With

' tried with and end with, then just calling the object by name

cmb_Hdr_Select1.Left = 5
cmb_Hdr_Select1.Top = 2
cmb_Hdr_Select1.Width = 4.5
cmb_Hdr_Select1.Height = 10

Neither seem to work. I must be doing something fundamentaly wrong, any help
appreciated.

Ray C

Duane Hookom · External Since: Feb 07, 2005 Posts: 1359

"Neither seem to work." I'm having trouble seeing the results of your
efforts. I expect your controls are very tiny. The default size and position
measures for controls on forms and reports is TWIPS. There are 1440 twips to
an inch. You might want to multiply your values by 1440 or whatever.
--
Duane Hookom
Microsoft Access MVP

"Ray C" wrote:

> I thought that I knew this but I must be wrong, please help.
> I want to change various parameters of text / combo boxes and Labels under
> prog control. The Form is called "Main" and i have tried the following to try
> and change the parameters of a combo box called "cmb_Hdr_Select1" :-
>
> Private Sub Form_Activate()
>
> With Forms.Main.cmb_Hdr_Select1
> .Left = 5
> .Top = 2
> .Width = 4.5
> .Height = 1
> .Visible = True
>
> End With
>
> ' tried with and end with, then just calling the object by name
>
> cmb_Hdr_Select1.Left = 5
> cmb_Hdr_Select1.Top = 2
> cmb_Hdr_Select1.Width = 4.5
> cmb_Hdr_Select1.Height = 10
>
> Neither seem to work. I must be doing something fundamentaly wrong, any help
> appreciated.
>
> Ray C

Ray C · External Since: Jul 15, 2006 Posts: 96

Twips, Twips, where the $$$ does it tell you anything about Twips?? I know
that the Properties gives box measurements in "cm" but I tried adding all
kinds of "cm" to the program and it just crashes. So, what i need to do to
get a box 2 cm wide by 1 cm tall is to convert from cm to inches and multiply
by1440. Wow, who said access was easy.

Dane, Thank you so much for your help.

Ray C

"Duane Hookom" wrote:

> "Neither seem to work." I'm having trouble seeing the results of your
> efforts. I expect your controls are very tiny. The default size and position
> measures for controls on forms and reports is TWIPS. There are 1440 twips to
> an inch. You might want to multiply your values by 1440 or whatever.
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Ray C" wrote:
>
> > I thought that I knew this but I must be wrong, please help.
> > I want to change various parameters of text / combo boxes and Labels under
> > prog control. The Form is called "Main" and i have tried the following to try
> > and change the parameters of a combo box called "cmb_Hdr_Select1" :-
> >
> > Private Sub Form_Activate()
> >
> > With Forms.Main.cmb_Hdr_Select1
> > .Left = 5
> > .Top = 2
> > .Width = 4.5
> > .Height = 1
> > .Visible = True
> >
> > End With
> >
> > ' tried with and end with, then just calling the object by name
> >
> > cmb_Hdr_Select1.Left = 5
> > cmb_Hdr_Select1.Top = 2
> > cmb_Hdr_Select1.Width = 4.5
> > cmb_Hdr_Select1.Height = 10
> >
> > Neither seem to work. I must be doing something fundamentaly wrong, any help
> > appreciated.
> >
> > Ray C

Duane Hookom · External Since: Feb 07, 2005 Posts: 1359

Help states
"In Visual Basic, use a numeric expression to set the value of this
property. Values are expressed in twips."

--
Duane Hookom
Microsoft Access MVP

"Ray C" wrote:

> Twips, Twips, where the $$$ does it tell you anything about Twips?? I know
> that the Properties gives box measurements in "cm" but I tried adding all
> kinds of "cm" to the program and it just crashes. So, what i need to do to
> get a box 2 cm wide by 1 cm tall is to convert from cm to inches and multiply
> by1440. Wow, who said access was easy.
>
> Dane, Thank you so much for your help.
>
> Ray C
>
> "Duane Hookom" wrote:
>
> > "Neither seem to work." I'm having trouble seeing the results of your
> > efforts. I expect your controls are very tiny. The default size and position
> > measures for controls on forms and reports is TWIPS. There are 1440 twips to
> > an inch. You might want to multiply your values by 1440 or whatever.
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> >
> > "Ray C" wrote:
> >
> > > I thought that I knew this but I must be wrong, please help.
> > > I want to change various parameters of text / combo boxes and Labels under
> > > prog control. The Form is called "Main" and i have tried the following to try
> > > and change the parameters of a combo box called "cmb_Hdr_Select1" :-
> > >
> > > Private Sub Form_Activate()
> > >
> > > With Forms.Main.cmb_Hdr_Select1
> > > .Left = 5
> > > .Top = 2
> > > .Width = 4.5
> > > .Height = 1
> > > .Visible = True
> > >
> > > End With
> > >
> > > ' tried with and end with, then just calling the object by name
> > >
> > > cmb_Hdr_Select1.Left = 5
> > > cmb_Hdr_Select1.Top = 2
> > > cmb_Hdr_Select1.Width = 4.5
> > > cmb_Hdr_Select1.Height = 10
> > >
> > > Neither seem to work. I must be doing something fundamentaly wrong, any help
> > > appreciated.
> > >
> > > Ray C

Ray C · External Since: Jul 15, 2006 Posts: 96

I stand corrected.

Thanks Duane

"Duane Hookom" wrote:

> Help states
> "In Visual Basic, use a numeric expression to set the value of this
> property. Values are expressed in twips."
>
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Ray C" wrote:
>
> > Twips, Twips, where the $$$ does it tell you anything about Twips?? I know
> > that the Properties gives box measurements in "cm" but I tried adding all
> > kinds of "cm" to the program and it just crashes. So, what i need to do to
> > get a box 2 cm wide by 1 cm tall is to convert from cm to inches and multiply
> > by1440. Wow, who said access was easy.
> >
> > Dane, Thank you so much for your help.
> >
> > Ray C
> >
> > "Duane Hookom" wrote:
> >
> > > "Neither seem to work." I'm having trouble seeing the results of your
> > > efforts. I expect your controls are very tiny. The default size and position
> > > measures for controls on forms and reports is TWIPS. There are 1440 twips to
> > > an inch. You might want to multiply your values by 1440 or whatever.
> > > --
> > > Duane Hookom
> > > Microsoft Access MVP
> > >
> > >
> > > "Ray C" wrote:
> > >
> > > > I thought that I knew this but I must be wrong, please help.
> > > > I want to change various parameters of text / combo boxes and Labels under
> > > > prog control. The Form is called "Main" and i have tried the following to try
> > > > and change the parameters of a combo box called "cmb_Hdr_Select1" :-
> > > >
> > > > Private Sub Form_Activate()
> > > >
> > > > With Forms.Main.cmb_Hdr_Select1
> > > > .Left = 5
> > > > .Top = 2
> > > > .Width = 4.5
> > > > .Height = 1
> > > > .Visible = True
> > > >
> > > > End With
> > > >
> > > > ' tried with and end with, then just calling the object by name
> > > >
> > > > cmb_Hdr_Select1.Left = 5
> > > > cmb_Hdr_Select1.Top = 2
> > > > cmb_Hdr_Select1.Width = 4.5
> > > > cmb_Hdr_Select1.Height = 10
> > > >
> > > > Neither seem to work. I must be doing something fundamentaly wrong, any help
> > > > appreciated.
> > > >
> > > > Ray C

Douglas J. Steele · External Since: Jan 12, 2009 Posts: 165

It's not necessary to convert from cm to inches before converting to twips.
There are 567 twips to the centimter, so multiply the dimension in cm by
567.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Ray C" <RayC DeleteThis @discussions.microsoft.com> wrote in message
news:C0FD6B94-0C0A-4C06-A8E4-E2E70AF1FB7D@microsoft.com...
> Twips, Twips, where the $$$ does it tell you anything about Twips?? I know
> that the Properties gives box measurements in "cm" but I tried adding all
> kinds of "cm" to the program and it just crashes. So, what i need to do to
> get a box 2 cm wide by 1 cm tall is to convert from cm to inches and
> multiply
> by1440. Wow, who said access was easy.
>
> Dane, Thank you so much for your help.
>
> Ray C
>
> "Duane Hookom" wrote:
>
>> "Neither seem to work." I'm having trouble seeing the results of your
>> efforts. I expect your controls are very tiny. The default size and
>> position
>> measures for controls on forms and reports is TWIPS. There are 1440 twips
>> to
>> an inch. You might want to multiply your values by 1440 or whatever.
>> --
>> Duane Hookom
>> Microsoft Access MVP
>>
>>
>> "Ray C" wrote:
>>
>> > I thought that I knew this but I must be wrong, please help.
>> > I want to change various parameters of text / combo boxes and Labels
>> > under
>> > prog control. The Form is called "Main" and i have tried the following
>> > to try
>> > and change the parameters of a combo box called "cmb_Hdr_Select1" :-
>> >
>> > Private Sub Form_Activate()
>> >
>> > With Forms.Main.cmb_Hdr_Select1
>> > .Left = 5
>> > .Top = 2
>> > .Width = 4.5
>> > .Height = 1
>> > .Visible = True
>> >
>> > End With
>> >
>> > ' tried with and end with, then just calling the object by name
>> >
>> > cmb_Hdr_Select1.Left = 5
>> > cmb_Hdr_Select1.Top = 2
>> > cmb_Hdr_Select1.Width = 4.5
>> > cmb_Hdr_Select1.Height = 10
>> >
>> > Neither seem to work. I must be doing something fundamentaly wrong, any
>> > help
>> > appreciated.
>> >
>> > Ray C

Duane Hookom · External Since: Feb 07, 2005 Posts: 1359

I wish the U.S. would have switched measure systems to metric back when I was
in grade school. Life would have been so much simpler.

--
Duane Hookom
Microsoft Access MVP

"Douglas J. Steele" wrote:

> It's not necessary to convert from cm to inches before converting to twips.
> There are 567 twips to the centimter, so multiply the dimension in cm by
> 567.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Ray C" <RayC.RemoveThis@discussions.microsoft.com> wrote in message
> news:C0FD6B94-0C0A-4C06-A8E4-E2E70AF1FB7D@microsoft.com...
> > Twips, Twips, where the $$$ does it tell you anything about Twips?? I know
> > that the Properties gives box measurements in "cm" but I tried adding all
> > kinds of "cm" to the program and it just crashes. So, what i need to do to
> > get a box 2 cm wide by 1 cm tall is to convert from cm to inches and
> > multiply
> > by1440. Wow, who said access was easy.
> >
> > Dane, Thank you so much for your help.
> >
> > Ray C
> >
> > "Duane Hookom" wrote:
> >
> >> "Neither seem to work." I'm having trouble seeing the results of your
> >> efforts. I expect your controls are very tiny. The default size and
> >> position
> >> measures for controls on forms and reports is TWIPS. There are 1440 twips
> >> to
> >> an inch. You might want to multiply your values by 1440 or whatever.
> >> --
> >> Duane Hookom
> >> Microsoft Access MVP
> >>
> >>
> >> "Ray C" wrote:
> >>
> >> > I thought that I knew this but I must be wrong, please help.
> >> > I want to change various parameters of text / combo boxes and Labels
> >> > under
> >> > prog control. The Form is called "Main" and i have tried the following
> >> > to try
> >> > and change the parameters of a combo box called "cmb_Hdr_Select1" :-
> >> >
> >> > Private Sub Form_Activate()
> >> >
> >> > With Forms.Main.cmb_Hdr_Select1
> >> > .Left = 5
> >> > .Top = 2
> >> > .Width = 4.5
> >> > .Height = 1
> >> > .Visible = True
> >> >
> >> > End With
> >> >
> >> > ' tried with and end with, then just calling the object by name
> >> >
> >> > cmb_Hdr_Select1.Left = 5
> >> > cmb_Hdr_Select1.Top = 2
> >> > cmb_Hdr_Select1.Width = 4.5
> >> > cmb_Hdr_Select1.Height = 10
> >> >
> >> > Neither seem to work. I must be doing something fundamentaly wrong, any
> >> > help
> >> > appreciated.
> >> >
> >> > Ray C
>
>
>

John W. Vinson · External Since: Jan 29, 2004 Posts: 2505

On Mon, 12 Oct 2009 14:38:01 -0700, Duane Hookom
<duanehookom.DeleteThis@NO_SPAMhotmail.com> wrote:

>I wish the U.S. would have switched measure systems to metric back when I was
>in grade school.

"Take me to your liter!"
--

John W. Vinson [MVP]

Linq Adams via AccessMons · External Since: Jan 23, 2009 Posts: 4

We did switch, didn't we? I distinctly remember buying gasoline by the liter!
Or was it "petrol?" And I guess it was only for about 6 months, before the
pumps were changed back! Is it just me, or does it seem odd that England
doesn't use the "English" system, but the US does?

;0)> .

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200910/1

Duane Hookom · External Since: Feb 07, 2005 Posts: 1359

There is some interesting notes on U.S. and metrics at
http://lamar.colostate.edu/~hillger/dates.htm. I assume it's factual.

--
Duane Hookom
Microsoft Access MVP

"Linq Adams via AccessMonster.com" wrote:

> We did switch, didn't we? I distinctly remember buying gasoline by the liter!
> Or was it "petrol?" And I guess it was only for about 6 months, before the
> pumps were changed back! Is it just me, or does it seem odd that England
> doesn't use the "English" system, but the US does?
>
> ;0)> .
>
> --
> There's ALWAYS more than one way to skin a cat!
>
> Answers/posts based on Access 2000/2003
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200910/1
>
>