Full Version: Reserved Words In Captions
UtterAccess Forums > Microsoft® Access > Access Forms
SisterMiriamE
Hi,

This is probably a silly question, but is it alright to use a reserved word (e.g., date) as a caption in a form, so long as the control is named unreservedly?

Thanks!

Sr. Miriam Esther, osb
cheekybuddha
Yes!
GroverParkGeorge
The reason there are cautions against using reserved words is that references to those words in code, SQL or expressions can potentially confuse Access when it needs to resolve the meaning of the word. Did you mean "Date", the name of a field in a table, or "Date" the function that returns the current date?

If you refer in code to the caption on a label which contains a reserved word, it's conceivable that this problem could arise, but not very likely.
theDBguy
Hi Sister. I agree with both David and George. There's always a possibility of issues in almost everything, but Captions should be in the low end of the risk hierarchy. Cheers!
SisterMiriamE
That's great!

Many thanks,

Sr. Miriam Esther, osb
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.