UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Bound Text Box Cutting off Data from Memo Field    
 
   
KROUTD
post Nov 2 2007, 09:04 AM
Post #1

UtterAccess Addict
Posts: 138
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?
Go to the top of the page
 
+
R. Hicks
post Nov 2 2007, 09:17 AM
Post #2

UA Forum Administrator
Posts: 38,131
From: Birmingham, Alabama USA
Is the field being formatted in any way ???
Is the record source for the form using a Totals query ???

RDH
Go to the top of the page
 
+
KROUTD
post Nov 2 2007, 09:23 AM
Post #3

UtterAccess Addict
Posts: 138
No special formatting and it's just a straight pull from the query/table (no Totals).
Go to the top of the page
 
+
R. Hicks
post Nov 2 2007, 09:46 AM
Post #4

UA Forum Administrator
Posts: 38,131
From: Birmingham, Alabama USA
Post the SQL for the query for the form.

RDH
Go to the top of the page
 
+
KROUTD
post Nov 2 2007, 09:50 AM
Post #5

UtterAccess Addict
Posts: 138
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
FROM tbl_CRBD_ACTIONS
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;
Go to the top of the page
 
+
R. Hicks
post Nov 2 2007, 09:53 AM
Post #6

UA Forum Administrator
Posts: 38,131
From: Birmingham, Alabama USA
The "SELECT DISTINCT" will cause the memo field to truncate to 255 characters.

RDH
Go to the top of the page
 
+
KROUTD
post Nov 2 2007, 09:57 AM
Post #7

UtterAccess Addict
Posts: 138
I can change that in the query - no problem.

Curious - why does that cause the memo field to truncate?
Go to the top of the page
 
+
KROUTD
post Nov 2 2007, 10:04 AM
Post #8

UtterAccess Addict
Posts: 138
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.
Go to the top of the page
 
+
R. Hicks
post Nov 2 2007, 10:10 AM
Post #9

UA Forum Administrator
Posts: 38,131
From: Birmingham, Alabama USA
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 ...

RDH
Go to the top of the page
 
+
KROUTD
post Nov 2 2007, 10:18 AM
Post #10

UtterAccess Addict
Posts: 138
The query returns 443 records.
Go to the top of the page
 
+
KROUTD
post Nov 2 2007, 10:52 AM
Post #11

UtterAccess Addict
Posts: 138
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!!
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 06:45 PM