Single quote in form value is cutting off data

I am pulling data from an access database, the data contains a single quote, when data is displayed in a form field for modification, the info after the quote is cut off. here is my code:

<tr valign=top><td>Author(s)</td>
<td><input type=text size=50 id=txtAuthors name=txtAuthors value='<%= rs("Authors") %>'></td></tr>

so the name l'oreal comes back from the database with just the first letter l, what can I do? I have tried the replace function, but maybe my syntax is wrong.

<tr valign=top><td>Author(s)</td>
<td><input type=text size=50 id=txtAuthors name=txtAuthors value='<%= Replace(rs("Authors"), "'", "\'") %>'></td></tr>.

Thanks to anyone who gives it a try.

Remove the single quotes from around the value. See if that works

<input type=text size=50 id=txtAuthors name=txtAuthors value=<%= rs("Authors") %>>.

It's thinking that the single quote in the data is the end to the value!

I tried removing the single quote already, but that didn't work because only the first word in the field is returned. I need the quotes to capture the whole field. This technique works when the data is not being returned to a form field. I know it is the HTML that thinks the field is completed when it sees the quote in the data. I guess the question is how to tell html to escape the single quote. Is there a htmlencode for single quote?

This is what I use to retrieve the value in the field:

sAuthor = oRS("Authors")

value="<%=server.HTMLencode(sAuthor)%>"

for the insert into the db, I escape the single quotes.

Thanks for the response, in my question about the htmlencode, i did a little research and then realized it was the html code that was terminating the string when seeing the second single quote, so i simply changed my single quotes that delimits the value attribute into double quotes. then when the html sees the single quote it doesn't freak. thanks for your time.