Form Text Format Property - won't allow Rich Text selection RRS feed

  • Question

  • The BE is SQL Server Express - - and looking at the field's table property via the FE, it is stating that it is Long Text.

    When in a Form that is bound on this table, this field is needing to be Rich Text, but when attempting to select that option in the control's property for text format....while it offers both Plain and Rich text - - it will not allow the Rich Text to be selected...it just pops back to Plain Text.

    Am guessing something is inherited from the table field property but not knowing SQL Server much - not sure what / where this property would be located.  

    Anyone else have this issue??

    Wednesday, July 10, 2019 12:54 PM


  • Well I think I actually found a flaw in the software...… advice from SQL Server forum was to be sure the field property in the table was  nvarchar(max)  - which it was

    So the only work around that I can come up with is this:

    1. make the text box control unbound

    2. set the text property to Rich Text

    3. set the text box's control source back to the table/field

    If you do it this way - the Rich Text property sticks and the control works correctly as Rich Text.....but if it is bound to begin with, as noted, one cannot change it to Rich Text for some reason......

    Friday, July 12, 2019 10:41 PM