Concatenated field displays only with old data

[mattstrachan]

Hello there,

I am working on updating a database and ran into a problem with a concatenated field. I have a form "Product" that is being recreated to match what my employer would like to see. On this form I have added a header field that will give a product description. It works great with the data currently in the database but when I attempt to add new data, it will not populate this field. Any suggestions?

This is what I have used to create the field. Am I missing something that would make this not update when new data is entered?

=StrConv([Prod_Work],3)+" "+StrConv([Shape],3)+" "+[Hue]+" "+[Origin]+" "+StrConv([Variety],3)

I could upload the db if needed, just let me know. Thank you!

 

[pbaldy]

That's the control source of a textbox? One problem you may be having is that "+" propagates Nulls, "&" does not. Switch to "&" and see what happens.

 

[mattstrachan]

Well that was a simple fix! Works perfect now. Case closed. Thank you.

 

[pbaldy]

Happy to help, and welcome to the site by the way! Sometimes you want +, but usually & is best.