Field - Text Box

  • Thread starter Thread starter Lost
  • Start date Start date
L

Lost

I'm inputting a note in the field text box and this will be saved as the last
entry. When I go back into this box, the order of the entries will be all
messed up. It will be marked as 2 entries before. I don't have any sorting
order on the form. It just sorts itself by computer time. It will just take
the last entry and put it in 2 entries before. Please help.
 
 I don't have any sorting
order on the form.  It just sorts itself by computer time.  It will just take
the last entry and put it in 2 entries before.  Please help.
Click to expand...

There are a couple things to look at.....

First of all, are there other fields in the table that stores the data
and if so, are any of them indexed? If so, the form may be sorted
based on an index in the table.

Secondly, if it is a requirement of your application that the items be
sorted in the order entered, consider adding an autonumber field to
the table and sort by it in the form.

Lastly, an alternative to the autonumber field is to have a date/time
field to hold the date and time the record was create or last updated
and sort by it.

Bottom line is you may need to "Tell" access explicitly how you want
the data to be ordered.

HTH
 
techrat said:
There are a couple things to look at.....

First of all, are there other fields in the table that stores the data
and if so, are any of them indexed? If so, the form may be sorted
based on an index in the table.

Secondly, if it is a requirement of your application that the items be
sorted in the order entered, consider adding an autonumber field to
the table and sort by it in the form.

Lastly, an alternative to the autonumber field is to have a date/time
field to hold the date and time the record was create or last updated
and sort by it.

Bottom line is you may need to "Tell" access explicitly how you want
the data to be ordered.

HTH
.
Click to expand...

I have a date/time field to the text box....so, when I'm updating a new
entry... it will pick up the current computer time/date. for example
03/24/2010 6:59PM - My message
and store it as the last entry.
When I come back to this file later, the last entry will show 02/18/2010
8:05AM - My message...the 03/24/2010 message will be two text messages above
the 02/18/2010.
It always bumps the last entry two messages prior to the last updated message.
 
I have a date/time field to the text box....so, when I'm updating a new
entry... it will pick up the current computer time/date. for example
03/24/2010 6:59PM - My message
and store it as the last entry.  
When I come back to this file later, the last entry will show 02/18/2010
8:05AM - My message...the 03/24/2010 message will be two text messages above
the 02/18/2010.  
It always bumps the last entry two messages prior to the last updated message.
Click to expand...

If I understand correctly, you are storing the date and time
concatenated together with your message in a single field. If this is
correct, it is at the root of your troubles. You need to have the date/
time stamp in a field on its own to sort by otherwise the entire
textbox value is sorted which will not give the results you are after.

HTH
 
Back
Top