A07 RTF w/SQL Server

[Neil]

I was reading on the Microsoft web site that to use the Rich Text property
in Access 2007, that you needed to set the table field's TextFormat property
to RichText, in addition to setting the text box's property as well. Where
does that leave SQL Server users?

If one uses SQL Server as a back end, one cannot set the TextFormat property
(since it doesn't exist). Would setting the property (if it even exists) in
the ODBC link to the SQL Server table suffice to be able to use the property
with a SQL Server back end? Or is using the new RichText property with a SQL
Server back end out of the question?

Thanks!

Neil

 

[Rick Brandt]

I was reading on the Microsoft web site that to use the Rich Text
property in Access 2007, that you needed to set the table field's
TextFormat property to RichText, in addition to setting the text
box's property as well. Where does that leave SQL Server users?

If one uses SQL Server as a back end, one cannot set the TextFormat
property (since it doesn't exist). Would setting the property (if it
even exists) in the ODBC link to the SQL Server table suffice to be
able to use the property with a SQL Server back end? Or is using the
new RichText property with a SQL Server back end out of the question?

Thanks!

Neil

It appears to work fine with a SQL Server text field. Setting the text format
property to Rich Text on the link does take even though you get the warning that
certain aspects of linked tables cannot be altered.

If you don't even bother to set the text format of the link field and just do it
in the form it gives you a warning, but still works.

 

[Neil]

Great! Thanks! Wondering something: does setting or not setting the RichText
property in the back end affect whether nor not you can access the plain
text in the field? The Microsoft Rich Textbox Control had a feature where
you could just see the plain text through a property of the text box. Is
that available with the RichText property, and does whether or not you set
the property in the back end affect that?

Thanks!

Neil