Sub Form Dates not in order of typing

[SoniaD]

I have a subform which has a file name, date field and a comment field. Basically someone enters a date and then a comment. However, when more than one comment is entered the dates do not run in order for example I may have 09.09.15 then 10.09.15 then 15.09.15 but the last comment on the form will be 10.09.15 date. Is there a way to get the dates in order of entry? Also the comment field is a long text field and if the text is longer than the box provided it continues to accept the information but will not display all the information and you have to scroll to read everything that was entered. Is there a way to avoid having to do this. Any help would be very much appreciated. thanks

[June7]

Must apply sort criteria on the date field.

Textboxes on form do not shrink/grow, that's why they have the scroll bar. So, answer is no. Either size the textbox to accommodate longest possible input or work with scroll bar.

[orange]

When someone updates the long text field, you can place the new comment and date at the start of the long text field. That way the latest comment will be first, and older comments will be in sequence.
**** Untested ****

Longtextfield = "  "

after updating with comment1

longtextfield = "dateA  first comment" 
( I would consider a "-" before the date --could simplify parsing in future)
(you could add a vbcrlf to get a new line in display on form)

after updating with comment2

longtextfield = "dateb  comment number two
                      "dateA  first comment"

after updating with comment 3

longtextfield = "-date x Comment number 3"
                      "-dateb  comment number two
                      "-dateA  first comment"

code could be

longtextfield = "-" & Date & "  " & newcomment & longtextfield & vbcrlf

[June7]

Is each comment a new record?

[orange]

In my sample -- no.
It would use the Longtext field to record comments on a specific topic.That's how I interpreted the post. I woudn't use the long text field as a record repository. I'd have comments in a related table.

[June7]

And I was thinking individual records in my reply.

If you are using LongText (Memo) type field and entering multiple comments in one record, consider ColumnHistory method. https://msdn.microsoft.com/en-us/lib...or=-2147217396

It is another type of multi-value field with hidden table maintained by the app. I've never used it and don't think I ever would. I would also use a related table with date and comment in separate fields and each comment would be a new record.

I avoid Memo fields as much as possible. They have issues.

[SoniaD]

thanks June7 I am new to access so not sure how to sort by date. We are entering multiple comments for each record depending on activity for that day so one record may have 50 or so comments

[orange]

Sonia,

Before getting too deep into the nitty-gritty of Access, you should do some research (reading/tutorials etc) of database concepts and design.

Here are a few sites that may be useful:
http://www.ucl.ac.uk/archaeology/cis...ual/node1.html
Post 3 at https://www.accessforums.net/access/...les-43061.html

And for Access
https://www.youtube.com/playlist?lis...03jQ_t9nFV737s

Good luck.

[June7]

Well, can't sort by date with that structure. As noted, I would not do that.

Why would the comments not be displayed in the date order? Why would a comment dated 15.09.15 be entered before 10.09.15?