Nov 2 2007, 09:04 AM
I have a bound text box on my form that is sourced from a 'Memo' field. Everytime this field exceeds 255 characters only the characters/text after the 255th character is displaying in the field. I've searched this forum for help but nothing touches on that exact problem. How can I have the text box display all the characters?
Nov 2 2007, 09:17 AM
Is the field being formatted in any way ???
Is the record source for the form using a Totals query ???
Nov 2 2007, 09:23 AM
No special formatting and it's just a straight pull from the query/table (no Totals).
Nov 2 2007, 09:46 AM
Post the SQL for the query for the form.
Nov 2 2007, 09:50 AM
Here it is.
SELECT DISTINCT tbl_CRBD_ACTIONS.CA_Key, tbl_CRBD_ACTIONS.CRBD_NUMBER, tbl_CRBD_ACTIONS.CRBD_REV, tbl_CRBD_ACTIONS.ACT_NO, tbl_CRBD_ACTIONS.CRBD_ASSOC_CHG, tbl_CRBD_ACTIONS.CRBD_ORG, tbl_CRBD_ACTIONS.ACT_DUE_DT, tbl_CRBD_ACTIONS.CRBD_TITLE, tbl_CRBD_ACTIONS.ACT_CLSD_DT, tbl_CRBD_ACTIONS.ACTION, tbl_CRBD_ACTIONS.ACT_EFFECTIVITY, tbl_CRBD_ACTIONS.ACT_MAN_EFF, tbl_CRBD_ACTIONS.LAST_UPDT_DT, tbl_CRBD_ACTIONS.CRBD_PCIN, tbl_CRBD_ACTIONS.CRBD_ANALYST, tbl_CRBD_ACTIONS.CRBD_Act_Assoc_LE, tbl_CRBD_ACTIONS.ACT_SE_Comments
WHERE (((tbl_CRBD_ACTIONS.ACT_CLSD_DT) Is Null))
ORDER BY tbl_CRBD_ACTIONS.CRBD_NUMBER, tbl_CRBD_ACTIONS.CRBD_REV, tbl_CRBD_ACTIONS.ACT_NO, tbl_CRBD_ACTIONS.CRBD_Act_Assoc_LE;
Nov 2 2007, 09:53 AM
The "SELECT DISTINCT" will cause the memo field to truncate to 255 characters.
Nov 2 2007, 09:57 AM
I can change that in the query - no problem.
Curious - why does that cause the memo field to truncate?
Nov 2 2007, 10:04 AM
Now that I've removed 'DISTINCT' from the query nothing populates on my form (not even the fields). My form opens and it's completely blank.
Nov 2 2007, 10:10 AM
Sounds like the query is not returning any records ...
An empty recordset can cause the problem you are now experiencing.
See if the query is returning any records ...
Nov 2 2007, 10:18 AM
The query returns 443 records.
Nov 2 2007, 10:52 AM
I've re-created the form (using the same query without the word 'DISTINCT') and it works fine. Must of had some buried code in the other one that was causing it to bomb. Now, everything is working fine. Thanks for all your help!!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here