![]() Me.Requery in your VBA script after every necessary event and also in your main form (generally the 'After Update' event is used most), and be wary that too many Me.Requery's (in unnecessary events) can also be detrimental - so too much of a good thing can be a bad thing.īottom Line Up Front - Modify the format of your query that is to be exported/printed. It pays to be across all properties of every object type in your database, as a change in a field property can cause unpredictable erratic effects, which take ages to figure out why it happened and how to stop it from happening again, whilst delivering your desired outcome. ![]() Scenario - Split Form (Form + Datasheet). I know this is late to the party and most likely going to be the last comment anyone reads, but this can be done quite simply in MS Access 2016 - by someone like myself who has no more than 4 days experience in databasing overall and no experience with writing custom Macro's or VB Script (using only what is native to MS Access). W = GetSetting("propertiesDBS", Me.Name, ctrl.Name, 0) SaveSetting "propertiesDBS", Me.Name, ctrl.Name, ctrl.ColumnWidth If (ctrl.ControlType = acTextBox Or ctrl.ControlType = acComboBox) Then Save the form and reopen to check results. I came across same issue today and found solution on this link.įor anybody else having same issue, use following code (I modified the code a little because original code from the above mentioned post saves column width of only text boxes but my form has combo boxes too, column width of which was not getting saved) in close and open events of your subform and then open main form in Form View and then manually select desired widths either by mouse, by entering column width value or using best fit. I see this post is quite old and OP must have figured someway to tackle the issue.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |