Thanks Dave. Having looked at your comment you of course answered my question. Clearly and succinctly.
The comment below was really regarding my other question as to how to change a field from Text to Date. That too was a bit tricky.
For the other question I was asking I discovered that in the data sheet mode you can change a field from text to date to integer, etc. after you click on the “Properties” in the top right of the window.
You cannot get this window when you are in a form. It is not intuitive. In a form when you click on the field when in Design Mode you have the 7 options but none of them will allow you to change a field from Text to Date or Integer, for example.
Jim noted that too in his response to my question.
Thanks for the assistance Amigo. All questions for today are answered. It was quite a battle!