Prev: Open form to ID and add in the record if not there
Next: Text box with help instruction
From: Jason on 6 Jun 2010 17:34
For a form I am using ControlBoxField.ListWidth = 7.5 (or any other value)
but resizes the drop down list width to the width of the drop down box. The
help states that the value can not be less than the width of the control
box - being larger should be fine. Instead I have to use
ControlBoxField.ListWidth = 5000. The field for List Width under form (below
column widths and list rows) is still set to 7.5. So why the different
values required?

Thanks,
J.


From: ruralguy via AccessMonster.com on 6 Jun 2010 17:56
Hi Jason,

I think you will find the values need to be in TWIPS (1440 = 1 inch I think)

Jason wrote:
>For a form I am using ControlBoxField.ListWidth = 7.5 (or any other value)
>but resizes the drop down list width to the width of the drop down box. The
>help states that the value can not be less than the width of the control
>box - being larger should be fine. Instead I have to use
>ControlBoxField.ListWidth = 5000. The field for List Width under form (below
>column widths and list rows) is still set to 7.5. So why the different
>values required?
>
>Thanks,
>J.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

From: Jason on 6 Jun 2010 19:12
Thanks for that, I was wondering about that - it does not state that for
listwidth but did for something else. I'll try the formula 1440/2.54*7.5
(4251) but that seems too small as I am using 6000. It looks like 2032 or
thereabouts = 1".

"ruralguy via AccessMonster.com" <u12102(a)uwe> wrote in message
news:a923d488ebd5e(a)uwe...
> Hi Jason,
>
> I think you will find the values need to be in TWIPS (1440 = 1 inch I
> think)
>
> Jason wrote:
>>For a form I am using ControlBoxField.ListWidth = 7.5 (or any other value)
>>but resizes the drop down list width to the width of the drop down box.
>>The
>>help states that the value can not be less than the width of the control
>>box - being larger should be fine. Instead I have to use
>>ControlBoxField.ListWidth = 6000. The field for List Width under form
>>(below
>>column widths and list rows) is still set to 7.5. So why the different
>>values required?
>>
>>Thanks,
>>J.
>
> --
> RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
> Please post back to this forum so all may benefit.
>
> Message posted via http://www.accessmonster.com
>


From: ruralguy via AccessMonster.com on 6 Jun 2010 19:26
Why are you dividing by 2.54? 1440*7.5 should be 7.5 inches.

Jason wrote:
>Thanks for that, I was wondering about that - it does not state that for
>listwidth but did for something else. I'll try the formula 1440/2.54*7.5
>(4251) but that seems too small as I am using 6000. It looks like 2032 or
>thereabouts = 1".
>
>> Hi Jason,
>>
>[quoted text clipped - 13 lines]
>>>Thanks,
>>>J.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

From: Marshall Barton on 6 Jun 2010 20:15
Jason wrote:
>Thanks for that, I was wondering about that - it does not state that for
>listwidth but did for something else. I'll try the formula 1440/2.54*7.5
>(4251) but that seems too small as I am using 6000. It looks like 2032 or
>thereabouts = 1".


It is definietly 1440 twips per inch.

I think your calculation would be correct for 7.5
centimeters, but maybe 7.5 centimeters is not wide enough.

--
Marsh
MVP [MS Access]
 |  Next  |  Last
Pages: 1 2
Prev: Open form to ID and add in the record if not there
Next: Text box with help instruction