How to set a default value

[amjad171]

I have a table for which I have set up a form for people to input data into the database, is it possible for me to set a default value of:

<ul>
<li> </li>
<li> </li>
<li> </li>
</ul>

In one of the columns which is named description?

Many thanks

 

[missinglinq]

You can either do this in Table Design View by selecting the field then going down to Default Value and entering it, or in Form Design View by selecting the control then going to Properties- Data and entering it in the Default Value Property there.

Linq

 

[amjad171]

Hi,

I tried adding

 <ul> <li> </li> <li> </li> <li> </li> </ul>

in the default value in the table design view, however this brings up a message saying:

<b>The expression you entered contains invalid syntax </b>

Is there another possible way around to this?

Thanks

You can either do this in Table Design View by selecting the field then going down to Default Value and entering it, or in Form Design View by selecting the control then going to Properties- Data and entering it in the Default Value Property there.

Linq

 

[missinglinq]

You'd have to place it in quotaions marks. IF this is all the default for one field

"<ul> <li> </li> <li> </li> <li> </li> </ul>"