>I have a form that displays data from an Access table.
>All the input fields are only showing the first word of whatever data is in the field of the table.
>
>For instance
>MyTable.Company = "The Omnia Group"
>the field on the form displays "The"
>
><INPUT
> TYPE=TEXT
> ID="txtCompany"
> NAME="txtCompany"
> SIZE="30"
> MAXLENGTH="30"
> VALUE=<%= objRecordSet.Fields("Company").Value >
>
>
>
>If I print the field to the page I get the whole content
>
>objRecordSet.Fields("Company").Value= <%= objRecordSet.Fields("Company").Value
>
>displays
>objRecordSet.Fields("Company").Value=The Omnia Group
>
>How can I get the complete content?
>
>TIA,
>Rick
Rick;
I do not know if this will help but give it a try. This is how I create a text box and populate it. Also, this allows the maxlength property to be dynamic and if your have to change field lengths (never happens) you do not have to touch any code.
As for the missing data, that is strange!
By the way I use absolute positioning as my forms have legal requirements and have over 150 objects on them. Also, we use I.E., which is our corporate standard. Using another browser can be "interesting". :)
<input style="HEIGHT: 20px;
LEFT: 130px;
POSITION: absolute;
TOP: 37px;
WIDTH: 60px;
FONT-SIZE: 9pt;"
id="txtCompany"
name="txtCompany"
value=" < %=trim(oRS("Company"))%>"
ReadOnly
maxlength=" < %=oRS.fields("Company").definedsize%>">
Tom