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

Karl

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

Subscribe Post Reply

4420

fredg

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

Marshall Barton

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

Karl

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

fredg

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

Similar topics

Setting control properties

by: John Hargrove | last post by:

I'm having trouble setting decimal place values in the results field of a sample management database I'm building for an environmental testing laboratory. The degree of sensitivity varies among...

Microsoft Access / VBA

Determining where a control is on a form; header, detail, or footer

by: Salad | last post by:

Is there a way to determine which section of a form a control is located in code....besides using the tag property?

Microsoft Access / VBA

Setting font size of text box in VBA

by: dixie | last post by:

I want to be able to set the font size and font type for text in a text box on a report using VBA. I wan't to be able to control it from a setting in a table. The problem is that I don't know the...

Microsoft Access / VBA

Setting height of detail section in VBA

by: dixie | last post by:

I know I've asked this question in the last week, but no matter how hard I look, I can't find it. So I'll type it again. Is it possible to set the height of the detail section of a report using...

Microsoft Access / VBA

Setting Subreport SourceObject Property

by: CSDunn | last post by:

Hello, I currently have an Access 2003 ADP Report/Subreport set up in which I have 12 subreports in a single main report that are located in a group header called 'PermnumHeader' (Permnum would be...

Microsoft Access / VBA

OLE Bound Control

by: Brian Keanie | last post by:

I had asked a question about the above subject a few days ago and between Stephen Lebans and Rog received the following answer. Would someone please tell this *Air Head* .... 1 What is meant by...

Microsoft Access / VBA

How to format the detail of a dynamically created subreport

by: kmacon | last post by:

I have a form that contains a command button. The command button's OnClick event builds a report using the CreateReport and CreateReportControl functions and then opens the main report. I set...

Microsoft Access / VBA

"error_reporting" setting not being recognized in my php.ini file

by: laredotornado | last post by:

Hi, I'm using PHP 4.4.4 on Apache 2 on Fedora Core 5. PHP was installed using Apache's apxs and the php library was installed to /usr/local/php. However, when I set my "error_reporting"...

PHP

Hide report (detail) section via Code at Run time

by: sara | last post by:

Hi - Is it possible to hide the detail section of a report at run time? I have a report that prints all details, with summary lines. The user would like the report ALSO with just summary lines....

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General