Copy Paste Text Too Long error (1 Viewer)

[MsAccessNL]

I have a long text field when i paste a text in the table or in a form, i get message "Text too long to be edited" , If i copy smaller parts it will work. (25000characters wil work). I want to store a picture as Base64, this is a long text file. Pasting into NotePad works fine.

 

[arnelgp]

Base64 is a series of Byte array, meaning it is binary.
you need a VBA decoder to decode the base64.

 

[AHeyne]

Base64 can also be represented as a character string.

 

[arnelgp]

here is a demo, open form1.
see the code behind the buttons.
see the other modules.

 

[MsAccessNL]

That's not the problem. The Problem is that i can't past a long text (the base64 character string)

 

[CJ_London]

Can you not use code to assign the value rather than copy paste?

 

[MsAccessNL]

At the end, yes, but know with testing, its a pain in the.., Is this a normal error in access, with pasting large text files?

 

[sonic8]

Is this a normal error in access, with pasting large text files?

Yes. The Access Textbox control has a hard limit of ~64k characters.
It often starts to behave weird with a lot less characters already.

 

[MsAccessNL]

Yes. The Access Textbox control has a hard limit of ~64k characters.
It often starts to behave weird with a lot less characters already.

Thxs for the info.

 

[arnelgp]

here is an update, Base64 from Clipboard.
open Form1.