SisterMiriamE
Feb 10 2015, 09:59 AM
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
Feb 10 2015, 10:01 AM
Yes!
GroverParkGeorge
Feb 10 2015, 10:14 AM
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
Feb 10 2015, 10:51 AM
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
Feb 10 2015, 11:03 AM
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.