Virtually Inert Person
Windows 10 
Access 2016
You would have to open form(s) in design view but hidden and allow code to modify properties of the form and/or its controls. You will need to specify the view and window mode parameters:
is there a way to open a form in hidden view and change the properties all in one big pass
https://docs.microsoft.com/en-us/off...docmd.openform
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows 10 Access 2010 32bit
Really think the one big pass approach is not user friendly- so user has to twiddle their thumbs whilst the one big pass covers 39 forms and 10 reports when all they want to do is check a value and exit
Plus as already mentioned if the code requires opening a form in design view you cannot supply a .accde as design view, hidden or not is not an option
Expert
Windows 10 Access 2016
Okay, let's wrap up the number and currency formatting issues. I modified the original db to have a lot more functionality and you can test entering all kinds of numbers and how they display in a table or form. Note that for the Number types, the format is set to General Number. You can change that to see even more specific formats. Enjoy!
I hope this file uploads okey, the date/time the the uploader shows is all wrong for the file stored in my PC.
dtCurrFormatTest1.accdb
Simple table relationships ("faces" to "spaces" to "chairs")
Using "Like operator" on fields of type currency
Changing dynamically the format of a currency field " Price"
Posting Permissions
Reply With Quote