Data Type Issue

[Evagrius Ponticus]

Hi All,

I have a form with two large textboxes - MytxtA and MytxtB. The user enters comments in MytxtB then clicks a command button that takes the comment entered in MytxtB and concatenates it to whatever string is in MytxtA. Both textboxes are of the memo datatype.

I am running into a problem where when I run the code (which is really a query) to concatenate the strings, the data from MytxtB is getting cut off and not all of it is being combined. I don't think this could have anything to do with the size of the textboxes? Can anyone please advice?

Thanks,

 

[Joe4]

It looks like using concatenation on Memo fields cause them to be treated as Text and truncate them. See here: http://thedailyreviewer.com/server/view/concatenate-access-memo-fields-108329859

 

[Evagrius Ponticus]

Thank you Joe. Please forgive me for being dense - I didn't understand the solution proposed. Can you help Joe? Thanks!

 

[Joe4]

It looks like the solution may be for ASP/ASP.net.
Take a look at this workaround here instead: http://support.microsoft.com/kb/92892
(its amazing what a simple Google search can do!)

 

[Evagrius Ponticus]

Thank you Joe - I am going to try that now

 

[Norie]

Sorry for asking and I swore to myself I wouldn't - do you really have so much text that you need 2 memo fields?