Textbox into memo field

[access10000]

Hi

I have a database that is used to log details of phone conversations, (ie. call centre). It has come to light that the end parts of some records are missing.

There seem to be various strange goings on including chopping off characters after 255 when it writes to a table - which I can understand in itself. However, sometimes this is 241, 594 etc. and sometimes the last few characters before it cuts off are turned into symbols from a character map, (which one I couldn't say).

I have searched the internet and found some reports that say a text box is limited to 255 characters and some to 65500/65536, and even that in vba it cannot go over 255. I am aware that it can be restricted to less than 255 but can someone confirm if it can actually go over this or what is up with the character symbols? The table it appends to is a memo field.

The fact that it needs to record a 'memo' field means it really needs to be able to take over 255 characters, and I do not want to use a 'characters free counter'.

The database itself is at work and is a lot more complex but the attachment should show the general issue. Entering into a textbox rather than straight into a memo field in a subform is certainly the tidy option for the form it is in.

If you paste say a couple of thousand characters into the textbox in form1, run the macro and look in table1a it should show the problem.

Any help appreciated.

Many thanks

 

[access10000]

I have added a new file which also includes about 13500 characters ready to paste into the textbox, to save people doing it themselves. 13500 will be ample.

cheers...

 

[boblarson]

Your problem is the query (one it isn't right and two going through the VBE grid didn't get it set up right).

So, check out the attached revision to your sample. I modified the code for the button (it bypasses the macro now) and does the duty directly in the button's click event.

 

[access10000]

Thanks Bob. Problem solved...

I follow the code and will apply it to my db, but if you could explain why it actually is that the query/macro version didn't work and why it wasn't a problem with the textbox I would be grateful to understand the problem as well as well as having the solution...

thanks for your help