Expression used in query not appearing in related form's field

[rebfein]

Hi there,



I created a query that has an expression field (it only took me 3 tries to get the expression right [Whooo hooo!]!


I used the expression field, along with a few other fields in a form:


However, when I set the form to a form view, the field appears like this:


The words, that should appear are Diode, Rectifier or what ever. The form field is set as a text field as are the combined fields. I don't know what is wrong.

Thank you for any assistance you can give me.

[ranman256]

That is correct. But you don't have to stick with Expr1, you can name it whatever you want.
but yes,just assign the box to the field in the query.

[CJ_London]

I presume the recordsource to your form is 'Nick' since that is the name of your query?

[Micron]

Assuming the rest of the form controls are bound to the same query as the misbehaving control, I'd reset the control source to any other field in that query, even if you already have it bound to some other control. If you then get data in the control, there could be an issue with the expression, which you should post. I'd switch it back and see what happens. If you don't get data from another field, I'd replace that control (delete, save/close/open, add new textbox). I looked for the obvious, such as having the same name for the query field and control, Name Autocorrect, but your textbox seems to be named Text100 or something like that. Form corruption is another possibility, since you should be able to bind a calculated query field to a textbox.

[rebfein]

Ranman256, Ajax, & Micron,

Thank you so much for your responses. The field is now working great.

Rebecca

[Micron]

If you would be so kind, we all benefit from knowing the solution. Others who have the same issue may end up here, but won't know what worked.