[AccessD] Rich Text Field Data from Azure Not Showing

David Emerson newsgrps at dalyn.co.nz
Thu Jun 25 00:10:54 CDT 2020


Hi Paul,

 

The limit is an estimation of the visible characters.  Because it is Rich Text there are all also the formatting characters that are not seen in the screen field but are stored in the table field.  The total number of characters I am guessing is 8000.  Whatever it is, it is not enough.  Changing it to varchar(MAX) allowed more characters to be stored but they weren’t being displayed in the Access screen textbox.

 

What would be nice would be to have the field as varchar(MAX) and also showing in the Access form J

 

Regards, David

 

From: Paul Hartland [mailto:paul.hartland at googlemail.com] 
Sent: Thursday, 25 June 2020 5:00 p.m.
To: David Emerson
Subject: Re: [AccessD] Rich Text Field Data from Azure Not Showing

 

Not long woke up, checked email and saw this this sounds very similar to a problem we had at an old company, when you say you are limited to about 3000 characters, do you mean in the rich text box field itself or the physical field of the table ? I think our problem was we had the data in the fields but unable to display it all in the rich text box.

 

Paul

On Thu, 25 Jun 2020, 04:50 David Emerson, <newsgrps at dalyn.co.nz> wrote:

Further to below, we can see the data in the fields in Access now but we
have the problem that we are limited to about 3000 characters depending on
the formatting (bold, italics, etc) which takes up extra storage.  The
client uses this field for pasting email body information which often goes
over this limitation.

Does anyone have a solution to this dilemma?

Regards,  David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David Emerson
Sent: Monday, 22 June 2020 7:59 a.m.
To: 'Access Developers discussion and problem solving'
Cc: 'Paul Hartland'
Subject: Re: [AccessD] Rich Text Field Data from Azure Not Showing

I was able to make the change to varchar(8000) and that fixed it.  Thanks
for your help.

Regards, David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David Emerson
Sent: Sunday, 21 June 2020 6:55 p.m.
To: 'Access Developers discussion and problem solving'
Cc: 'Paul Hartland'
Subject: Re: [AccessD] Rich Text Field Data from Azure Not Showing

I am reluctant to do that at this stage because it is their live data that
we are working on (the original UAT testing didn't show this as a problem)
:(

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Paul Hartland via AccessD
Sent: Sunday, 21 June 2020 6:43 p.m.
To: Access Developers discussion and problem solving
Cc: Paul Hartland
Subject: Re: [AccessD] Rich Text Field Data from Azure Not Showing

I think I remember something about this but only on mobile at moment so cant
look up any notes, is it possible to try changing the varchar from
varchar(max) to varchar(8000) as a quick test.

Paul


On Sun, 21 Jun 2020, 07:30 David Emerson, <newsgrps at dalyn.co.nz> wrote:

Sorry about the cross post but my client has decided to go live tomorrow and
there is an annoying problem I would like to solve.

They have an existing SQL Server database that has been migrated to Azure.
The Access front end is an accdb.  There are three tables that have
varchar(MAX) datatypes which are used to populate text fields in Access that
have their text Format properties set to Rich Text.  This works as expected
with the text in the fields being able to be formatted.

After migrating to Azure and only needing to change the connection strings
the Access file works as per the current system with the exception that the
Rich Text fields do not display any data!

I can enter data in the field and it saves to the table but as soon as I
refresh the screen nothing is shown in the field (it is still in the
underlying table in SQL though).

Normally I get the data for my forms using ADODB.Recordsets.  When I put a
msgbox line in the VBA to show the contents of the field it comes up with
Null.   However, when I create a direct link to the table in the Tables
Group and open the table I can see the text in the field with all the rich
text formatting.

Is there something about Azure and ADODB that doesn't like varchar(MAX) data
types?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand





More information about the AccessD mailing list