ok; a form has a record source; it is either a table or a query; when in
Design View look at Properties of the form - and near the top of the stack of
properties is the record source;
a form will display all the records from its record source; to reverse the
order in which they appear one manipulates the underlying record source via a
query; this was my first advice. one can simply change the record source by
selecting a new query in the propery box.
on the otherhand; a single text box within a table/form is limited to 255
characters unless it is defined as a Memo field. the text in an individual
field - just like the text in this message - can not be reversed...there is
no real way that I can make this 3rd paragraph appear as the first paragraph.
One must put the text into the field in the order in which you wish to see
it. So I see no feasible way to reverse the order of text within an existing
field - if that is your request.
by human and general default - people append notes 'below' (where the cursor
goes)... in order to force them to append/insert notes above/before - you
could have big instructions in RED...or would need to implement a creative
method - which I have done on several occasions. Add an unbound textbox to
the form and invite users to "Add Comment Here" (so they won't add directly
to the existing comments field). And then in the AfterUpdate Event of this
AddComment box you use code to insert the comment permanently at top:
Dim CommentS as String
CommentS=me.CommentBox
CommentS=me.AddCommentBox & " " & CommentS
me.CommentBox = CommentS
the space between the " " defines the white space between comments
CommentBox and AddCommentBox are just names I made up to be descriptive - -
you would of course use your real names...
I hope this helps - if I have missed understanding your question you should
probably open a new question.
--
NTC
mawd said:
The table that contains the Notes column is named "Projects", this code is
simply entered into a text box titled "Notes History" in a form named
"Project Details". So it looks like the answers to your questions are 1)
Yes, we're discussing a Form. If I'm in the wrong forum please point me to
the correct one. 2) "RecordSource" is not a reference to the code I'm
actually using, this is the exact code that is in my database. I would guess
that yes, this is the record sorce for the overall form. 3) This form is
getting the information for the Notes History from the Notes column within
the Projects table.
NetworkTrade said:
given you posted this in the Forms section I trust we are discussing a Form.
This code of yours: "=ColumnHistory([RecordSource],"Notes","[ID]=" &
Nz([ID],0))"
Is this the record source of the overall Form? If not, where is this code
in the Form and what then is the source of the Form.
--
NTC
mawd said:
I hope to answer your question correctly, but I will admit that I'm not well
versed in the nomenclatures and terminology used.
In the original "=ColumnHistory([RecordSource],"Notes","[ID]=" &
Nz([ID],0))" expression, "Notes" is a column within my "Projects" table.
That is what I would assume you are referring to.
:
where is this original expression being applied now?
--
NTC
:
I've created a query using the query wizard that looks at the Notes field of
table and it was saved as "Projects Query".
How do I edit the original expression to reference this query instead of the
table?
:
with the underlying query you can control the sort
if you are sourced directly on a table; create a query and change to source
on query
--
NTC
:
Hello,
I'm using the =ColumnHistory([RecordSource],"Notes","[ID]=" & Nz([ID],0))
expression and want the results to be listed newest to oldest.
I've searched all over and can't seem to find a way to do this. Can someone
here either confirm that there is no way to reversing this order, or explain
how to do it?
Thanks,
mawd
