By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Access Control Ignoring Format Assignment

P: 5
I am working in Access 2000. I have a form with a tab control with several pages, each one containing a form. The textboxes on these forms are not allowing me to set a format. When I click the Format in the properties there are no options. I tried typing in an appropriate format "Standard", and it does not work. I also tried forcing the format in the Control source property - =Format([Jan],"#,###") that did not work. Then I tried setting the format property using VB during the form load event, that also did not work. The formatting works fine in the footers where I have totals. Any idea? I am at a loss. Thanks,
Donna
Jan 3 '07 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I am working in Access 2000. I have a form with a tab control with several pages, each one containing a form. The textboxes on these forms are not allowing me to set a format. When I click the Format in the properties there are no options. I tried typing in an appropriate format "Standard", and it does not work. I also tried forcing the format in the Control source property - =Format([Jan],"#,###") that did not work. Then I tried setting the format property using VB during the form load event, that also did not work. The formatting works fine in the footers where I have totals. Any idea? I am at a loss. Thanks,
Donna
Assuming these are unbound text boxes you will need to set the datatype to number first before trying to set the format property.

Mary
Jan 4 '07 #2

P: 5
Assuming these are unbound text boxes you will need to set the datatype to number first before trying to set the format property.

Mary
The textboxes are bound, and the datatypes are numbers that go through a series of queries before ending up in my form, some of which are crosstabs...maybe that has something to do with it? I will check.
Jan 4 '07 #3

P: 5
The textboxes are bound, and the datatypes are numbers that go through a series of queries before ending up in my form, some of which are crosstabs...maybe that has something to do with it? I will check.
OK, looks like access stops recognizing the datatype once the data goes through an nz(). Any way to work around?
Jan 4 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
OK, looks like access stops recognizing the datatype once the data goes through an nz(). Any way to work around?
Are you putting in 0 for the default value of the nz().

Post the code for this and we'll have a look.

Mary
Jan 4 '07 #5

P: 5
Are you putting in 0 for the default value of the nz().

Post the code for this and we'll have a look.

Mary
Thanks Mary, but it looks like I found a fix...if I cast all as doubles Cdbl(nz()) it seems to work. Only problem is I have 16 queries X 12 months to edit. Actually that leads me to another question, I will post separately. Thanks again for your help.
Jan 4 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.