Text Box on Form Limits Entry to Memo Field?

[databasedonr]

I have a memo field in my table, with unbound text box on my form that I use to write back to this field, but the text box on the form limits my data entry. Any ideas?

I can physically go into the table and add the data, and view the data in the text box, but I can't add beyond 255 characters in the text box?

I have tried to find a memo box control to create an unbound field on the form, but ?? can't find one?

Thanks in advance.

 

[Rich]

Why not just bind the control?

 

[databasedonr]

Binding the control is great, unless you want to use an unbound control. I'm afraid this doesn't answer the question, which is why is there a limit on the text I can enter in a text box on a form, and how can I work round that with an unbound control.

 

[Leopardfist]

I'm having the same problem, it lets me enter as much as I want with the scroll bar on in the form... but as soon as I TAB out of that field, it cuts off all of the data entered that took over 255 characters. Mine are Bound and I have the can grow settings on for my form and report, as well as the vertical scroll bar.

 

[databasedonr]

Leopardfist:

I worked around this problem by writing a SQL query to load the data. I placed a "save" button on the form, and in the Events added this code:

Dim strSQL As String
strSQL = "UPDATE tblService SET tblService.Comments = """ _
& [Forms]![frmUpdateServiceData]![txtNewComments] & """ WHERE (tblService.ServiceID) = " _
& [Forms]![frmViewAll]![ServiceID] & ";"

DoCmd.RunSQL strSQL

Which solves the problem.

Prior to this code I run an update query that updates all the fields except my Comments field, which of course is updated separately by the code above.

Apparently, though, if you change the settings in the query (under Query >- Parameters) and identify the field as a Memo Type, this will also solve the problem. I haven't tried this, but....

Good luck.

 

[MossleyMike]

Unbound Memo

The Code certainly worked for me too Tried the Query/Parameters route - but then it fell over as the number of characters in the query was > 1024.

 

[RuralGuy]

Does this link offer any ideas? http://www.accessforums.net/ftopic5593.html

 

[databasedonr]

I would have to say I disagree with that post -- I am not doing any formatting, distinct selecting etc etc. I am merely running an update query that says "take the value from textbox on form and write it into memo field in table" and in the update query it truncates at 255 characters. Now, there may be an issue around Service Packs, because the IT folks where I toil don't believe that MS Service Packs are worth the time to install... and I am running O2KSP1.