Format not working

[chefdaveross]

I have a 2 text boxes in a form that will not display the correct format.
I have a % format and another currency.

my source for the box is

=[ComboBoxName].[column](#)

the source fields are correctly formatted

 

[Guus2005]

Please ask the question.
Do you get an error message? What?

 

[chefdaveross]

no error message,
just displaying my numbers as unformatted numbers.
for example .9 instead of 90% and .2643796945 instead of $.26
Have the proper formats selected in the properties too and in the tables and queries they come from

 

[boblarson]

no error message,
just displaying my numbers as unformatted numbers.
for example .9 instead of 90% and .2643796945 instead of $.26
Have the proper formats selected in the properties too and in the tables and queries they come from

Are you 100% sure that the formats are entered in the FORMAT property and not in the INPUT MASK property (I've seen that happen before).

Other than that, can you post the db or email it, if too big?

 

[chefdaveross]

I am 100% sure. I just double checked to make sure.
It is a textbox in a subform

 

[boblarson]

I am 100% sure. I just double checked to make sure.
It is a textbox in a subform

So, can you post it or email it so we can take a look and see if we can figure it out?

 

[chefdaveross]

i put too much time in it to make it public.
Its an awesome recipie database that updates all my costing when I input new pricing on my items.
As where I think its a simple concept, there are unique ideas and queries on there that perform lots of time consuming tasks

 

[boblarson]

Can you strip it so that only the one form, table and query are there? The only reason I ask is that we don't seem to be making any headway and I know for me, at least, I am more visual and when I can look at it and play with it, I can usually track down the problem in a matter of minutes.

But, if you don't feel comfortable with doing so, I can completely understand.

 

[chefdaveross]

I am having problems with the yeild, and cost text boxes on the subform. Total works fine.

I am also having difficulty with my sum total at the bottom which is a seperate issue

thanks

 

[boblarson]

I am having problems with the yeild, and cost text boxes on the subform. Total works fine.

I am also having difficulty with my sum total at the bottom which is a seperate issue

thanks

I'll have to look at it when I get home as it is in Access 2007 format and I only have that on my computer at home. So, that will be at least 8 hours away. Hopefully that won't mess you up too badly.

 

[chefdaveross]

appreciate it.
here is a 2000 format if that helps.
no rush nonetheless

 

[boblarson]

I hate to have you do it again, but there is at least one piece missing that needs to be there to troubleshoot it. That is the table ITEM_PRICING_PREP as it needs to be there for your combo box to work which then populates some fields.

 

[chefdaveross]

thanks again

any way i can get a recipie total to work on the bottom as well?

 

[boblarson]

thanks again

any way i can get a recipie total to work on the bottom as well?

I'll let you know as soon as I can see it in action.

 

[chefdaveross]

Ive tried every way i know to format my text boxes into proper formats.
It seems that there must be a conflict from the grouping of fields in the subform.
Could that be possible?

 

[boblarson]

Ive tried every way i know to format my text boxes into proper formats.
It seems that there must be a conflict from the grouping of fields in the subform.
Could that be possible?

When I was working on it I got everything to work fine but the total. That was what I had been continuing to work on.

 

[chefdaveross]

what is the problem with the formatting?
or should i be patient?

 

[boblarson]

Here's what I have so far.

 

[chefdaveross]

For % : It looks to me like you entered this in the control source

=Format([RecItem].[column](3),"Percent")

For currency [ItemCostTextBox]: It looks like you didnt do anything besides format to currency.

Am i correct?

 

[boblarson]

For % : It looks to me like you entered this in the control source

=Format([RecItem].[column](3),"Percent")

For currency [ItemCostTextBox]: It looks like you didnt do anything besides format to currency.

Am i correct?

I took the formats OFF of the tables though, I believe.