Search results

Thanks Romc - I have realised that now, but am too far into the db to change it. Fortunately it is not a very big database, so I will get away with the spaces this time.

Thanks Bryan. The "control source" refers to the text/combo box that I am working with, in this instance "MedicareNo" The table name is "Patient Details Table". I have compared this text box to other ones, and I can't see anything wrong. Perhaps I can't see the woods from the trees.:o

I am having problems with form design in access2007. My control source is "Patients Detail Form" My control is MedicareNo. In design view I create a form using Form Design, I add in a text box and under Properties, Control Source, I add the following =[Patient Details Table]![MedicareNo]...

Please please help! I keep getting a #name? error when trying to enter details on a form. What causes the error.

Hi, I can't set a leading 0 in my telephone area code. Access automatically resets the area code to a single digit (eg 08 is reset to 8). Can anyone give me a hand?

Thanks Chris

I'm a Access database designer, not new to it but still learning.