"Date" title as shown in a field

[Harrold]

Hi

I am trying to create a form for official receipts. However, in the process of creating one, i realise its field is linked to a new table, so i need to put down the field name in the table before creating a form.

But when i put the word "date" in a field. A warning message stated that it is a reserved word.

I need the word "date" shown in official template receipts. How can i go about it?

Thanks in advance

 

[Mr. B]

Give your field in your table a name for the date like "ProcessedDate". Then on your form, use the label of the control that will be linked to the "ProcessedDate" field and you can type "Date" in the label. The control will show the date value that is in the "ProcessedDate" field in the table but the label can just have the word "Date" or whatever you like.

You just cannot use "Date" as the name of the field in the table.

 

[John Big Booty]

Here's a list of other reserved words to avoid