Allen Pitts
asked on
Text in blocks with date stamp
Hello expert,
We are building an Access database to receive and maintain service requests.
A free text area is contemplated for notes so when new information is received or change in the
status of the request occurs it can be input.
But we are afraid that the Notes text area will become a jumbled mess.
Is there a way of inputting multiple blocks of free text that
1. Adds separate blocks of text
2. Has a date stamp or calendar drop down so each chunk of text has a date associated
with it.
3. Puts the most recent text block on top
Thanks
Allen in Dallas
We are building an Access database to receive and maintain service requests.
A free text area is contemplated for notes so when new information is received or change in the
status of the request occurs it can be input.
But we are afraid that the Notes text area will become a jumbled mess.
Is there a way of inputting multiple blocks of free text that
1. Adds separate blocks of text
2. Has a date stamp or calendar drop down so each chunk of text has a date associated
with it.
3. Puts the most recent text block on top
Thanks
Allen in Dallas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In Dale's solution, you would set the default property of the Req_Note_DT field = Date()
Or, if you might make more than one note on the same day,
Now()
Now()
The additional benefit of storing notes correctly is that you can also capture the ID of the person making the note and save that too.