Hi there Richard, you are an excellent teacher, thank you! Quick MS anomaly, I wondered if you knew about? LongText data type. After 2032 chars the text field will not update? Any thoughts? thanks.
@@599CD Thanks for replying. I look forward to your response on the QQ forum. I am a huge proponent of coherence and structure with any code development and your classes really help gaining a logical understanding of the subject matter.
I've always felt that short text is too short (255 bytes isn't even enough for a tweet) and long text 1 GB size is too big, and it's too bad there is nothing in between. SQL Server lets you specify text fields of any size with varchar(n). But if n > 255 and you import the field into Access, it's turned into long text instead.
Yeah... I've personally never had a problem with it. Usually if something goes over 100 characters or so, it goes in a Memo... er... I mean "Long Text" field. :)
I’d like to know how to append a table with more than 255CHR in long text field. Access truncates the characters to 255 despite it being a long text field. Interested if you or anyone has a solution
thumbs up as always for the GREATEST TEACHER Richard Rost who always makes our work life easier. Thank you for your valuable lesson 👍
This answered my question fast. Now back to work. Thank you.
Glad to help
Hi Richard another great video Steve..
Thanks
Hi there Richard, you are an excellent teacher, thank you! Quick MS anomaly, I wondered if you knew about? LongText data type. After 2032 chars the text field will not update? Any thoughts? thanks.
599cd.com/QQ
@@599CD Thanks for replying. I look forward to your response on the QQ forum. I am a huge proponent of coherence and structure with any code development and your classes really help gaining a logical understanding of the subject matter.
I've always felt that short text is too short (255 bytes isn't even enough for a tweet) and long text 1 GB size is too big, and it's too bad there is nothing in between. SQL Server lets you specify text fields of any size with varchar(n). But if n > 255 and you import the field into Access, it's turned into long text instead.
Yeah... I've personally never had a problem with it. Usually if something goes over 100 characters or so, it goes in a Memo... er... I mean "Long Text" field. :)
I’d like to know how to append a table with more than 255CHR in long text field. Access truncates the characters to 255 despite it being a long text field. Interested if you or anyone has a solution
When exactly is this happening? Tell me here: 599cd.com/Ask
I've always pronounced it ore-e-gun not ore-uh-gun
Thanks