Controlling Height Of Section In VBA

Mar 27, 2008

My report has the Section's Footer.
Each time the section runs, it will take up a different amount of space.
I have already run all the code, to move all the different controls to the top (and be invisible) when they are not needed.
So to the best of my knowledge, I have no controls sitting in the lower part of the section.
The last thing I run is:
Code: Me.S123.Height = Me.S123.Height - 300
s123 is the name of the Footer SEctions. The idea is that it gets progressively smaller.
This is all running in:
Code:Private Sub S123_Format(Cancel As Integer, FormatCount As Integer)

All the other things work.
Here is a sample of it all..
Code:If Me.txt2 = 0 Then Me.a2.Visible = False Me.b2.Visible = False Me.a2.Top = 0 Me.b2.Top = 0 Me.box.Height = Me.box.Height - 300 Me.S123.Height = Me.S123.Height - 300End IfIf Me.txt2 <> 0 Then Me.a2.Visible = True Me.b2.Visible = TrueEnd IfIf Me.txt3 = 0 Then Me.a3.Visible = False Me.b3.Visible = False Me.a3.Top = 0 Me.b3.Top = 0 Me.box.Height = Me.box.Height - 300 Me.S123.Height = Me.S123.Height - 300End If

This runs through 8 different numbers.
as I said, all the other things operate properly. They get hidden and move.


Any thoughts?

Thanks.

View Replies


ADVERTISEMENT

Reports :: Variable Row Height In Report Detail Section

Apr 16, 2013

In the detail section of my report, I recently added a second row which has only 1 text field. When the value of the textbox in the 2nd row is null, I want the total row height equal to just the first row. When the value in the textbox in the 2nd row is not null, then the total row height is equal to row 1 and 2. I tried to make the textbox in the second row invisible when it had a null value thinking that when it was null, the report would shrink to the first row height, but that didn't seem to work.

View 1 Replies View Related

Make Popup Form (Dialog)'s Height As Same As Window/Montior/Screen Height

May 7, 2008

Hi,

When the user click the button, then it will give out a popup form to the screen, but I want to make the popup form's height as same as the screen/window/monitor's height, because the popup form's height is larger than the screen's height, and every user's monitor's height is different. So, I have to make it flexiable change of the height of the popup form.
How can I check the screen/window height by VBA function?
In Excel, it has Application.Height to check. In MS Access Form, I cannot find one for doing that.

Please let me know if you have one.
Thanks.

View 1 Replies View Related

Form Height

Oct 26, 2004

I've many items to be put on a form. However, I can't expand the height of the form. The max height I can get is 55.873cm. Could anyone please teach me to expand it?

Many thanks.

View 3 Replies View Related

Applications Width And Height

Jan 20, 2006

Hi,
Does anyone know how to set the application's width and height? I have an access application and I want to resize the applicatoins' with and height, NOT the forms!
is this possible?

greetings
nelleh

View 1 Replies View Related

Height Of Window For Form?

Jun 5, 2006

Hi..

Is there anyone can help me?

how to create a form that automatically can make the form longer when user click a button?

thank you..

View 1 Replies View Related

Subform Height Problem

Oct 10, 2006

Hi everyone, have a problem which is probably very easy to fix but i cannot for the life of me figure out why it is happening. I'm hoping someone with more experience than me knows what this is and how to sort it. I have a form with controls at the top then a subform and then a series of buttons below the subform. I have recently added another control above the subform and moved the subform down, but this has caused the subform to appear partially covering the buttons appearing below it. Seems simple....shrink the subform. It doesn't work. In the design view the subform only has a height of 5cm but in the front end it seems to grow with the form as that increases in size. can grow has been set to no on the subform and the details section. Nothing i do seems to stop the subform from making it's own mind up about it's height!!!

Thanks in advance for any help

Dan

View 4 Replies View Related

Continuos Forms Height

Dec 5, 2006

I have a form which is set to display continuous forms - just like a table but a bit nicer to look at! is it possible to make the forms height vary depending on how many records there are?

thanks in advance!

Dave C

View 4 Replies View Related

Forms :: Set Pop Up Form To Be Height X Always

Apr 18, 2014

I have a pop up form that likes to change it's height after I enter design view among other things. I've searched the webs, but can't find out strictly how to set my pop up form to be height X and ALWAYS be height X no matter what.

The best answer I've found so far: [URL] ....

But as soon as I went back into the form in Design View the changes were lost.

Is there some VBA code I can use to resize the form every time it's opened?

View 2 Replies View Related

Caption Height In Datasheet View

Apr 28, 2006

I have a caption named original investment.

I want it to be displayed as

original
investment

at the column head not as

original investment

how do I do this?

thanks

View 3 Replies View Related

How Do I Set Control Height To 0 So That There Won't Be Any Space Between Printed Lin

Sep 21, 2004

How do I make the blank line disappear after the control is no longer visible? I tried to set the Height property to 0 in the OnPrint Event but I got an error message 2191, you can’t set height property after printing has started.

Thank you,

UongSaki

View 1 Replies View Related

Reports :: Changing Row Height For All Fields In A Row

Jun 11, 2013

I have an existing report with a number of fields arranged horizontally in a tabular fashion in the detail section. The first field is an identifying line of text and the remaining fields are numerical calculations. The report is basically a simple profitability estimate report for a number of different products.

Behind the fields of data is another text box that is blank, which stretches across all the horizontal fields, and which changes background color using conditional formatting. When printing, this colors the whole row according to that criteria (it changes color based on the relative profitability of each product in the report).

The problem I'm having is that the first line of identifying text can sometimes overflow.

I've set the Can Grow property to Yes for this and all other controls in the Detail section. But the result is sometimes some funny-looking formatting. The identifier (like "Product XYZ with a really long description") will word-wrap, but every other field in that row maintains their own height. In particular, this makes the coloring of the conditionally formatted row look off, because it provides only one line's worth of color, even though the product description has wrapped to two lines.

How I can resize all the controls in the Detail section based on the height of the tallest control, and keep the whole thing dynamic?

Things I've tried: I've tried putting some VBA in either the OnFormat or the OnPrint events that iterates through the controls in the section and resets their heights. In the "OnFormat" event, nothing happens (no errors and no apparent changes in the appearance of the report). In the "OnPrint" event, I get an error that says the height property cannot be changed during a print or print preview.

The VBA I tried using was as follows:

Code:
Dim ctlIt As Control
Dim lngMaxHeight As Long
For Each ctlIt In Me.Controls
If ctlIt.ControlType = acTextBox Then

[Code] ....

View 1 Replies View Related

Forms :: Fixing Height Of Pop-up Form

Mar 10, 2015

Since many years I "fight" with pop-up forms, as in endless view I cannot figure out HOW to fix the height.

Some forms keep a height which was set by the System and it is suitable others have the full height of the Screen and I cannot find any Setting which can influence them.

How to define or to fix the height.

It only works when I set the border to "changeable", but not when I want to fix a height by Setting the border to "Dialog" ....

View 8 Replies View Related

Modules & VBA :: Set Height Of All Form Headers

Dec 16, 2013

I have built a database and I want to set the height of the form header on all forms using a module.

I am uncertain how to write the VBA to accomplish this task.

View 2 Replies View Related

Controlling Changes To Combo Box

Jan 17, 2007

I have a form. In it is a status field that can be:

NEW
SENT
CREDIT
COLLECT
CLOSED

When the item is created, it is given a "NEW" Status. And there is a command button on the form that can change the status to "SENT". However, based on external factors (email received or system report examined) the user can manually change the status to the CREDIT, COLLECT or CLOSED. Now, I want to make sure that then can't change the status manually to "SENT", only the system is allowed to do that via the command button.

How can I allow them to use some of the allowed values, but not others?

David

View 1 Replies View Related

Reports :: Max Height For Details On Multipage Report

Sep 18, 2014

I have a report which will be printed on preprinted paper. On this paper a footer is printed with e.g. address info.

The report has a detail section with a height of 3,5 inch and canGrow=true.

The reportFooter contains totals. The size of this footer, and placements of the fields prevents printing data on the pre-printed footer of the paper.

But when the report has multiple pages, the report footer will be printed on the laste page, and the detail section is expanding to the bottom of the paper, overwriting the pre-printed footer. I need a max height of the detail section, or another solution.

View 3 Replies View Related

Reports :: Automatically Adjusting Height Of A Control

Aug 18, 2014

I have a report that prints lab tests. One section has 4 columns that are framed. Only the first control (STest) expands to more than one line. The Can Grow works on this control and subsequently the section expands. I need a code that expands the height of the other three controls to match that of STest. I am using office 2010.

View 11 Replies View Related

Reports :: Fixing Report Height And Width

Sep 6, 2013

How to fix the height and width of a report. I would like the report to stay landscape, 100mm wide, 62mm high. This is required by a label printer.

The issue is that a A4 laser printer has to be set as default (for other software) so when the report is launched the size is set to the default printer size, when I select the label printer it fails as it is the wrong size.

View 1 Replies View Related

Updating Another DB And Controlling From A Differnt DB

Jun 16, 2005

Hello All,

How would I run a procedure in DB2 from DB1?

View 3 Replies View Related

Whats Controlling These Decimals?

Jan 5, 2007

Hello,

Dont understand what is controlling these decimals. I dont need any decimals for this database. The currency is talking bout money in 1000's and the probability is whole numbers.

Here is where I cant get the decimals to stop:

http://img80.imageshack.us/img80/3685/untitled2pl2.png
http://img77.imageshack.us/img77/6276/untitled3pa6.png
http://img208.imageshack.us/img208/2047/untitled3lk8.png

I have tried different things but no luck...anyone have any suggestions.

Thanks.

View 10 Replies View Related

Controlling Time/date

Jan 12, 2007

In a simple access table, I have the follwiing:

Data type: Date/Time

Format: mm/yyyy
Input Mask: 99/99

It restricts me to enter 2006 for instance. It converts to 2007. I want to be able to enter any year. Please help. Thank you.

View 2 Replies View Related

Controlling Subforms With A Combo Box

Jun 29, 2005

Is it possible to control the data of a subform by making selection in a combo box?

View 2 Replies View Related

Controlling Forms And Subforms

Dec 10, 2006

Howdie y'all

I need a few pointers wrt the relationship between a form and its subform.

I have the following form:

http://i88.photobucket.com/albums/k193/bernmc/Misc/DefaultStaffingscreenshot.jpg

Top part of the form is for adding/editing etc.

The subform is based on a query. The two are linked on the 'week' value.

Now, this is what I want to do:

The user must not be able to edit data in the subform (so should I use a report instead... but then will I be able to do 2...).
Selecting a row in the subform should cause the whole form to go to that record so that the user can then modify info in the fields of the main form.

I don't know VB - the only code I've used is gleened from searching these forums (a great resource, so I'm learning slowly), so I'll need a bit more than 'Do a wrzmitchigob on the bleedlethrop'!

View 10 Replies View Related

Forms :: Auto Height Of Subform On Base Of Records

Apr 28, 2015

i have a subform (A) which shows records after an query..i want to set height of subform on base of records as some time query shows 2 records and some time it shows 10 records..how can i set auto height of sub form

View 5 Replies View Related

Controlling The Real World With Access?

Feb 6, 2006

Hi there,

Is it possible to control a lighting system from Access using a combination of VBA code or Active X add ons with some specialist hardware and cabling attached to the PC, etc ?

To be more specific, I've designed a Snooker Hall Management program and want to be able to turn the lights on over the Snooker table when you start a game in an Access form...My application has 8 tables but could be expanded obviously.

I'm happy with the Access side of things (first attempt at a real world solution, etc) but to be totally polished a hardware interface to control the lights would really create a 'wow' factor...

Any help or direction would be greatly appreciated :)

Regards

dazza61

View 4 Replies View Related

Combo Box Controlling Multiple Subforms

Apr 21, 2005

Hi,

I'm v.new to Access so do excuse my ignorance.
I have a form with a combo-box with the following values:
Trust, Course, Overseas, GP
When Trusts is selected I'ld like frmtrust_sub to appear.
When anything else is selected I'ld like frmnontrust_sub to appear
Once the data has been entered in the subform the user would continue back to the main form.
I'ld like the subforms to remain hidden until needed, if possible so as not to confuse users.

I’ve copied this piece of code and have tried pasting it into the “after update” event procedure but I get this error message

“the link masterfields property section has produced this error “Ambiguous name detected: Type_afterupdate”


Private Sub Type_AfterUpdate()

Option Compare Database

Sub ShowSubform()

'Save unsaved changes to currently open subform
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

'Display appropriate subform based on Type chosen
If Type = "Trust" Then
frmtrust_sub.Visible = True
frmnontrust_sub.Visible = False

ElseIf Type = "GP" Then
frmnontrust_sub.Visible = True
frmtrust_sub.Visible = False

ElseIf Type = "Course" Then
frmnontrust_sub.Visible = True
frmtrust_sub.Visible = False

ElseIf Type = "Overseas" Then
frmnontrust_sub.Visible = True
frmtrust_sub.Visible = False

ElseIf Type = "Other" Then
frmnontrust_sub.Visible = True
frmtrust_sub.Visible = False


End If

End Sub

Private Sub cmdClose_Click()

'Close form
DoCmd.Close

End Sub

Private Sub Form_Current()

'Call subroutine to display appropriate subform based on template type
ShowSubform

End Sub

Private Sub Type_AfterUpdate()

'Call subroutine to display appropriate subform based on template type
ShowSubform

End Sub


Any help would be greatly appreciated

thanks

Barry

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved