[AccessD] Rich Text Field Data from Azure Not Showing

[Paul Hartland]

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:

> Hi Listers,
>
>
>
> 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
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>