(simple) Expressions give error message

[P.Hofman]

I've just started working with access and I'm encountering a problem at the very start. Perhaps it's just a simple issue, but help files and browsing this forum doesn't give the answer.

I've made a very simple table with customer contact information. I have a field for "street" and a field for "number". When I'm making a form I want to combine them. I'm using [street] & " " & [number] as expression and I get an error message (. Combining other fields sometimes works and sometimes gives the same error. All the fields are defined as text fields, so I'm not sure where the difference comes from.



What am I doing wrong?

Edit: Ok I've found it myself 5 minutes after making this post.....
The name the wizard gives to the box is the same as the field name, combining it with other field names made it think it was a circular problem. Changing the name of the textbox was the solution.

[Rainlover]

A valuable lesson indeed.

Remember this one as it will bite you again.

Always name Text Boxes etc differently to the Control Source.

[P.Hofman]

I created the form using the wizard. So I guess I have to change the names myself if I want to do 'extra' things to a text box.

[Rainlover]

I always name my Text Boxes with txtNameOfField

The wizard will find this Control Name.