Form computation

[galaxy24]

I have a form which has three fields. Field 1 and field 2 need to be added together with the total being displayed in field 3. After inputing 100 in field 1 and 500 in field 2 this is what I have displaying so far:

Field 1 displays: 100
Field 2 displays: 500
Field 3 displays: 100500

This is what I need it to display:
Field 1 displays: $100
Field 2 displays: $500
Field 3 displays: $600

This is what I have in my fields:
Field 1: ALH-NFRONT
Field 2: ALH-NBACK
Field 3: =[ALH-NFRONT]+[ALH-NBACK]



I checked the properties of fields 1, 2, and 3 and the format is set to currency with 0 decimal places. I am not sure what additional settings need to be made to have the currency show with the proper comptation.

Any input would be helpful.

Thank you.

[John_G]

Sounds as if your fields are not numeric, but are text format. Check the field type setting in the underlying table.

John

[JoeM]

That should work. Are Field1 and Field2 bound or unbound fields?
If they are bound fields, what is the data type of the fields that they are bound to?

[June7]

By fields you mean textboxes bound to table fields?

Are these fields Number type with Currency format or Currency type? I have tested both and cannot replicate the issue. If you want to provide db for analysis, follow instructions at bottom of my post.

[galaxy24]

John-that did the trick! Thank you for the help. Its not often I work in Access but I added this info to my notes. I should be good to go on this next time! And thanks to the others who gave thier input as well. Have a good one!