<div> in Query results
- Thread starter Weekleyba
- Start date
I can. And the <div> disappears.
But, I do want the rich text option.
I change the T_Update table to Rich Text and the Form field where this gets inputted from the user to Rich Text.
I then get this when turning font to red. (first row only turned to red font)
Why doesn't the query show the red font?
But, I do want the rich text option.
I change the T_Update table to Rich Text and the Form field where this gets inputted from the user to Rich Text.
I then get this when turning font to red. (first row only turned to red font)
Why doesn't the query show the red font?
- Local time
- Yesterday, 20:41
- Joined
- Oct 29, 2018
- Messages
- 22,040
Yes, that sounds about right.
I guess I don't really need to view the query so I guess it doesn't matter.
The form and report shows red which is what I really needed.
It took a bit to make it work for some reason. The form text box would did not allow me to change it to Rich Text until I first took the off the Total Query. Then it allowed me to change it to Rich Text, then I changed the query back to Totals and it worked. Weird....
The form and report shows red which is what I really needed.
It took a bit to make it work for some reason. The form text box would did not allow me to change it to Rich Text until I first took the off the Total Query. Then it allowed me to change it to Rich Text, then I changed the query back to Totals and it worked. Weird....
- Local time
- Yesterday, 22:41
- Joined
- Feb 28, 2001
- Messages
- 28,637
The fact that it works correctly in on DB but not in another probably means that some setting is different. From the main screen, select File >> Options and then browse around in Current Database (one of the options) on both machines. Also a possibility: Object Designers and Client Settings (two other options). One of those three is your culprit, I would think. If you find settings that are different between the two, experiment. You can go back later and reverse the settings you changed.
I'm still stumped on this one.
Below is an example of the problem.
I shrunk the query to just two tables. T_Project and T_Update.
See tables below and then the simple query.
Then I change it to a Totals query and it truncates my UpdateComment field.
Why does this happen?
Then, since I want the last update in a report, I change this query to a totals query.
Below is an example of the problem.
I shrunk the query to just two tables. T_Project and T_Update.
See tables below and then the simple query.
Then I change it to a Totals query and it truncates my UpdateComment field.
Why does this happen?
Then, since I want the last update in a report, I change this query to a totals query.
- Local time
- Yesterday, 20:41
- Joined
- Oct 29, 2018
- Messages
- 22,040
Because to totals a query, the records have to be grouped. And when you group a text field, Access stops at 255 characters to speed things up.
What you want to do is don't include the Long Text field in the Totals query and just add it later using a different query.
Last edited:
Gasman
Enthusiastic Amateur
- Local time
- Today, 04:41
- Joined
- Sep 21, 2011
- Messages
- 15,651
Check out the the first link?
https://www.google.com/search?q=tot...3i22i29i30.18083j0j7&sourceid=chrome&ie=UTF-8
Why not just get the record with the max date for each ptoject whatever?
https://www.google.com/search?q=tot...3i22i29i30.18083j0j7&sourceid=chrome&ie=UTF-8
Why not just get the record with the max date for each ptoject whatever?
I'm not sure what is going on with this??
I recreated the query and now it works. Go figure.
Both queries are shown below. The first one is the OLD one with the problem of truncating.
I recreated the query, with everything basically identical and it worked.
Access glitch???
I recreated the query and now it works. Go figure.
Both queries are shown below. The first one is the OLD one with the problem of truncating.
I recreated the query, with everything basically identical and it worked.
Access glitch???
Part of the issue is, sometimes the Property Sheet for the query will show the Text Format field for the text fields and sometimes it will not show it.
Note below for the UpdateComment field, the Text Format is not shown.
Then with the new query, that is identical to the old one, it does show the Text Format.
Note below for the UpdateComment field, the Text Format is not shown.
Then with the new query, that is identical to the old one, it does show the Text Format.
Mike Krailo
Well-known member
- Local time
- Yesterday, 23:41
- Joined
- Mar 28, 2020
- Messages
- 1,341
Unrelated to the question but in post #1, your T_Engineer table contains a field for EngineerFullName, that is not necessary to store that since you are already storing the first and last name already. Just use a query to create the full name where needed.
I also see the possibility to eliminate the long text field by using a Notes table that just splits up all those individual note entries into smaller sensible components. Then, when an actual update is made, it is in a subform that has the NoteID, ProjID, NoteDate, Action, comment. Using a query could piece all those parts back together for display on a form or in a report.
Here is an example of one that I use. Of course this assumes that no individual comment would exceed 255 characters. If that happens, I usually just split the comment into two different notes as required.
I also see the possibility to eliminate the long text field by using a Notes table that just splits up all those individual note entries into smaller sensible components. Then, when an actual update is made, it is in a subform that has the NoteID, ProjID, NoteDate, Action, comment. Using a query could piece all those parts back together for display on a form or in a report.
Here is an example of one that I use. Of course this assumes that no individual comment would exceed 255 characters. If that happens, I usually just split the comment into two different notes as required.