By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Setting width of control on detail section of report using On Format

P: n/a
How do you set the width of a control in the detail section of a report
using the On Format event for the detail section?

Aug 9 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Thu, 09 Aug 2007 22:20:01 GMT, Karl wrote:
How do you set the width of a control in the detail section of a report
using the On Format event for the detail section?
If [SomeControl] = "Whatever" Then
[SomeControl].Width = 2 * 1440
Else
[SomeControl].Width = 1*1440
End If

Note: All measurements are in twips (1440 per inch) so the above code
would chanbge the width from 1 inch to 2 inches if the criteria is
met.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 9 '07 #2

P: n/a
Karl wrote:
>How do you set the width of a control in the detail section of a report
using the On Format event for the detail section?

Me.controlname.Width = inches * 1440

--
Marsh
Aug 9 '07 #3

P: n/a

I don't have a width option for the control. In the OnFormat event for the
Detail section, I typed

me.col1.w

and width is not a choice.

I'm using A2000

I have a 13 second Jing video showing this at
http://www.screencast.com/t/_KkRsnP_han

"Marshall Barton" <ma*********@wowway.comwrote in message
news:tl********************************@4ax.com...
Karl wrote:
>>How do you set the width of a control in the detail section of a report
using the On Format event for the detail section?


Me.controlname.Width = inches * 1440

--
Marsh

Aug 10 '07 #4

P: n/a
On Fri, 10 Aug 2007 14:37:30 GMT, Karl wrote:
I don't have a width option for the control. In the OnFormat event for the
Detail section, I typed

me.col1.w

and width is not a choice.

I'm using A2000

I have a 13 second Jing video showing this at
http://www.screencast.com/t/_KkRsnP_han

"Marshall Barton" <ma*********@wowway.comwrote in message
news:tl********************************@4ax.com...
>Karl wrote:
>>>How do you set the width of a control in the detail section of a report
using the On Format event for the detail section?


Me.controlname.Width = inches * 1440

--
Marsh
So what!!!
Type it out completely. Access Intellisence is not always correct.
For example, it will not show a Visible property for a PageBreak
control, but the control has one.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Aug 10 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.