Last edited by Blings; 07-20-2021 at 01:29 AM. Reason: Grammar clean-up
To me that's one of those worthless properties. It only works when you print a form, not view it. Most of never print forms, so...worthless.
In terms of using the can grow/shrink properties of the form they only apply when the form is printed.
You can do it with vba for a single form, not a continuous form but on my phone so no access to code. Google ‘Stephen lebans’ who has done a lot of work around visual presentation including resizing controls based on content
If you don't need to edit the data in the form then you can display a report in a form and that can grow and shrink in a continuous report style.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Thanks. I'll resize the text box in the mean time to be double the size, however, I don't really like this solution but it'll have to do for now. I've found this article by 'Stephen Lebans', I'll need to adjust my Access operating bit down to 32-Bit in order to take a look.
That's quite a nice idea, however, users of the dB need to add notes which that tab (Notes) of the form is the section to do so.
I don't really like my practical application in the sense the user needs to navigate to the bottom of the form to add a new record. When they close and reopen the form the latest date will then appear at the top.
Maybe I should do as you say whereby I display a report in the form. Perhaps I need to add a button to the right of the page named "Add New Note" which will open a new window of Date and a text box for the user to capture their note against the project?
Your thoughts would be appreciated.
Have two sub forms. One only enters data and is at the top of the main form, and is a standard single form, if they need more space then let a double click of the text box open a zoom control on it.
Underneath it you mimic the form with a report that can grow to display the long text.
Sort it so the most recent at the top, so your notes are in the most sensible order.
No scrolling and easy data entry.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
That's an even better solution.
Thanks Minty.
Strangely, the form data entry type changes from "Yes" to "No" after a couple times of use... as I definitely hit the save button. Tested it, works okay. I came back today and it changed to "No".
Do we know what could cause this issue?
Shot in the dark, but make sure it isn't being opened with OpenForm in Edit mode, and then saved with Close and the appropriate save argument.
Using this to open the form:
This to close the form:Code:Private Sub QR_Click() 10 On Error GoTo QR_Click_Error 20 DoCmd.OpenForm "frmEditQuote", , , "[ProvisionalQuoteID]=" & [ProvisionalQuoteID] 30 DoCmd.Close acForm, "frmProvisionalQuotesListsubformKey" 40 On Error GoTo 0 50 Exit Sub QR_Click_Error: 60 MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure QR_Click, line " & Erl & "." End Sub
Code:Private Sub cmdClose_Click()10 On Error GoTo cmdClose_Click_Err 20 DoCmd.Close , "" 30 DoCmd.Close acForm, "frmEditQuote" 40 DoCmd.Close acForm, "frmProvisionalQuotesListsubform" 50 DoCmd.OpenForm "frmProvisionalQuotesListsubform" 60 [Forms]!frmProvisionalQuotesListsubform.Form.FilterOn = False cmdClose_Click_Exit: 70 Exit Sub cmdClose_Click_Err: 80 MsgBox Error$ 90 Resume cmdClose_Click_Exit End Sub
Solution:
Code:50 DoCmd.OpenForm "frmProvisionalQuotesListsubform", , , , acFormPropertySettings