Hi,
I manage a Access 07 dbase as part of my job. I am not very good at programming, no formal training. Most things it does by code I found snippets and modified them.
Something I want to do is have text box show on a form ONLY if a date field has a date in it. If it is empty the text box should be hidden.
The text box is a word in bold red "COMPLETED" . The control I want to manipulate it with is a date control labeled "DateCompleted" .
I have found some snippets but none that do exactly what I am looking for. I was thinking it should be a simple "if" function, but I just dont know enough keywords and syntax to write it.
Can one of you give me a hand?
jimmy
I manage a Access 07 dbase as part of my job. I am not very good at programming, no formal training. Most things it does by code I found snippets and modified them.
Something I want to do is have text box show on a form ONLY if a date field has a date in it. If it is empty the text box should be hidden.
The text box is a word in bold red "COMPLETED" . The control I want to manipulate it with is a date control labeled "DateCompleted" .
I have found some snippets but none that do exactly what I am looking for. I was thinking it should be a simple "if" function, but I just dont know enough keywords and syntax to write it.
Can one of you give me a hand?
jimmy