Constraints Question

[NearImpossible]

I used a query on the SQL server to set some constraints, one of which is below

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]

Hi. You could try using something like:

... DEFAULT 'Server: <br>Clients: '...

Hope it helps...

 

[NearImpossible]

Hi. You could try using something like:

... 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??

 

[NearImpossible]

yup, that works.

Thanks again !!

 

[theDBguy]

yup, that works.

Thanks again !!

Hi. You're welcome. Glad to hear you got it to work. Cheers!