Constraints Question (1 Viewer)

NearImpossible

Registered User.
Local time
Today, 05:33
Joined
Jul 12, 2019
Messages
225
I used a query on the SQL server to set some constraints, one of which is below
Code:
ALTER TABLE dbo.FacilityInformation 
     ADD CONSTRAINT RemoteConnection 
          DEFAULT 'Server: ' + char(13) + char(10) + 'Clients: '
               FOR [Remote Connection] ;

Which gave me a layout of

Server:
Client:

However after I changed the text format from Plain Text to Rich Text in the Access Properties, so I can make those entries Bold after I add additional data, it now appears as

Server: Client:

Whenever I add a new record. Is there anything I can add in the Constraint to make them Bold by default and appear as?

Server:
Client:
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:33
Joined
Oct 29, 2018
Messages
21,357
Hi. You could try using something like:
Code:
... DEFAULT 'Server: <br>Clients: '...
Hope it helps...
 

NearImpossible

Registered User.
Local time
Today, 05:33
Joined
Jul 12, 2019
Messages
225
Hi. You could try using something like:
Code:
... DEFAULT 'Server: <br>Clients: '...
Hope it helps...

so can I assume that I can use HTML tags in the constraints? basing this thought off of the <br> in your suggestion.

If that's the case DEFAULT '<b> Server: </b> <br><b> Clients: </b> ' should work??
 

Users who are viewing this thread

Top Bottom