Hi im trying to use text boxes to show text (that I have wrote in design view) on a form. I realise that i should have used labels but how can I show the text that I wrote in the text boxes on the form when the project runs?
I.E in Design view the text boxes have what i WANT written BUT when RUNNING it says "#name?" on the text boxes.
If you are getting a #name? error then most likely you need to add and equals sign in front of what you have typed. If you put and expression in the text box's Control Source property then you need to put an '=' at the beginning so Access knows to evaluate the expression. Without the =, Access is looking to match you 'Name' to a bound field name in the query or table.
="This is the current date " & Format(Date(),"m,d,yyyy")
The first example is evaluated to show:
This is the current date 12/14/2005
The second example looks for a field named CurrentDate to show its value.