G
Guest
I have an application which uses Format functions in text boxes on forms. It
is used by approximately 90 users at this location, but users at another
location see the "#Name?" error rather than the data in the textbox. We are
on the same version of MSOffice, MSAccess and Windows XP.
In some instances, the format function is entered in the properties box
under Default Value - "Format(Now(),"mm/dd/yyyy")
In other instances the DataSource concatonates data from several
fields"=Trim(CompanyName) & " " & City & ", " & State"
where CompanyName, City, and State are fields.
The data displays correctly if, on the form load event, I code "textbox1 =
format(now(),"mm/dd/yyy").
I could replace the date format using the format property (these were the
first forms I ever created and I didn't know about the format property then)
or perhaps vba code but the application has numerous forms and procedures
which use format functions - correcting every instance would require a huge
coding and testing effort and cannot be addressed at this time.
I appreciate any help.
is used by approximately 90 users at this location, but users at another
location see the "#Name?" error rather than the data in the textbox. We are
on the same version of MSOffice, MSAccess and Windows XP.
In some instances, the format function is entered in the properties box
under Default Value - "Format(Now(),"mm/dd/yyyy")
In other instances the DataSource concatonates data from several
fields"=Trim(CompanyName) & " " & City & ", " & State"
where CompanyName, City, and State are fields.
The data displays correctly if, on the form load event, I code "textbox1 =
format(now(),"mm/dd/yyy").
I could replace the date format using the format property (these were the
first forms I ever created and I didn't know about the format property then)
or perhaps vba code but the application has numerous forms and procedures
which use format functions - correcting every instance would require a huge
coding and testing effort and cannot be addressed at this time.
I appreciate any help.