Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-12-2019, 07:20 PM   #1
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 145
Thanks: 75
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Constraints Question

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:

NearImpossible is offline   Reply With Quote
Old 12-12-2019, 07:25 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,294
Thanks: 66
Thanked 1,685 Times in 1,640 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Constraints Question

Hi. You could try using something like:
Code:
... DEFAULT 'Server: <br>Clients: '...
Hope it helps...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 12-12-2019, 07:33 PM   #3
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 145
Thanks: 75
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Re: Constraints Question

Quote:
Originally Posted by theDBguy View Post
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??

NearImpossible is offline   Reply With Quote
Old 12-12-2019, 07:36 PM   #4
NearImpossible
Newly Registered User
 
Join Date: Jul 2019
Posts: 145
Thanks: 75
Thanked 1 Time in 1 Post
NearImpossible is on a distinguished road
Re: Constraints Question

yup, that works.

Thanks again !!
NearImpossible is offline   Reply With Quote
Old 12-12-2019, 07:53 PM   #5
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,294
Thanks: 66
Thanked 1,685 Times in 1,640 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Constraints Question

Quote:
Originally Posted by NearImpossible View Post
yup, that works.

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

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get Constraints to work Andyonline Queries 4 05-09-2010 05:19 AM
Check Constraints- how to? urbanbluebee Tables 3 12-20-2007 09:40 AM
count and constraints swathin Tables 3 09-02-2005 10:54 AM
[SOLVED] Reports Constraints Bigman Reports 2 10-30-2003 03:19 AM
[SOLVED] other subset constraints nanna Tables 1 09-25-2003 07:20 PM




All times are GMT -8. The time now is 06:56 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World