continuous forms on popup only displaying one record unless I expand the window

[kenethlevine]

Hello

I am fairly new to Access and am having a problem for which I am trying everything without success. It is access 2003.

I have a main form. When the user presses a button a modal popup comes up with a continuous form based on a database table. I am manually linking the table to the main form table rather than as a subform, but either way I get this problem. When the popup comes up, even though there are 3 records, I only see one. If I expand the popup downwards I see the other records. I want them to be shown from the start.

Properties for the popup form are:

Default View: Continuous forms
Allow Form View: Yes
Scroll Bars: Vertical Only
Record Selectors: Yes
Navigation Buttons: Yes
Dividing Lines: Yes
Auto Resize: No
Auto Center: No

the detail section of the popup form has:

Force New Page: None
New Row or Col: None
Keep Together: yes
Visible: yes
Display When: Always
Can Grow: Yes
Can Shrink: yes

I have tried every combination I can think of as well as enlarging the detail section but that just makes more space for each record in the popup. Any help would be appreciated.

[kenethlevine]

It suddenly works. All I did was make it a subform again, put it outside the visible part of the parent form, and make it so that, in design mode, the subform form is in the middle of the screen.

Anyway, I truied undoing anything I had done and it still works, justa s before nothing I did could make it work. Since I am not learning from my mistakes, I am doomed to repeat them, unless someone can shed light on this.

Thanks!

[NeoPa]

You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.

ADMIN.

[Jim Doherty]

It suddenly works. All I did was make it a subform again, put it outside the visible part of the parent form, and make it so that, in design mode, the subform form is in the middle of the screen.

Anyway, I truied undoing anything I had done and it still works, justa s before nothing I did could make it work. Since I am not learning from my mistakes, I am doomed to repeat them, unless someone can shed light on this.

Thanks!

Hi Kenneth,

As a workaround use this

Create a standard module and paste this below the Option Compare Database line

 
Declare Function GetDesktopWindow Lib "user32" () As Long
Declare Function GetWindowRect Lib "user32" (ByVal hWnd As Long, rectangle As RECT) As Long
 
Function getScreenResolution() As String
    Dim r As RECT
    Dim hWnd As Long
    Dim retval As Long
    hWnd = GetDesktopWindow()
    retval = GetWindowRect(hWnd, r)
    getScreenResolution = (r.x2 - r.x1) & "x" & (r.y2 - r.y1)
End Function
 
 

Now for 'pop ups' and windows such as those I personally place them wherever I want dynamically but for 'starters' if you want to try this one you'll see what I mean.... it will place your popup top left of screen each time (out of the way so to speak and size the length to fit the resolution either 800x600 or 1024x768:

In the On Open event of the form place the following code

On Error Resume Next
If getScreenResolution() = "1024x768" Then
DoCmd.MoveSize 0, 0, , 10980
Else
DoCmd.MoveSize 0, 0, , 8500
End If

Bit rough and ready but it ought to facilitate you for what you need

Regards

Jim :)

[NeoPa]

Unfortunately, as we have no accurate log of all the changes you made, and in which order, there is little to go on to determine what caused it to start working I'm afraid.
I'm sorry to be unable to help as you've provided a lot of relevant info and laid it out carefully too.
Maybe someone else will see something I missed.

[missinglinq]

I think this is what's happened:

a modal popup comes up with a continuous form... When the popup comes up, even though there are 3 records, I only see one. If I expand the popup downwards I see the other records.

The form at this point was continuous, and in Design View, the OP had way too much empty space between the bottom of the text boxes and the bottom of the form, which meant that there was a lot of "white space" between each row of data, forcing the OP to expand the form to see all three records.

It suddenly works. All I did was make it a subform again, put it outside the visible part of the parent form, and make it so that, in design mode, the subform form is in the middle of the screen.

When the form was made into a subform again, the form was no longer a continuous form but rather a Datasheet form, which is the default view for a subform! Since Datasheet forms are formatted similar to spreadsheets or queries, all three rows were automatically "snugged" up to each other, resolving the problem. When a form is displayed in Datasheet mode, Access ignores any and all formatting that apperars in Design View and so the extra empty space disappeared. If the form is changed back to Continuous view I suspect the problem will re-appear.
Linq ;0)>