Field Length

S

smk23

I have a SQL view I use as a recordset for a report. One of the text columns
is truncated and when I look at the view Design screen from Access, the field
length is only 7 which is not correct. I need about 30. Anyone know how to
correct this?
 
W

Wayne Morgan

You need to modify the structure of the SQL Server table that the view is
pulling the data from. I'm not familiar enough with SQL Server though to
tell you how to edit the table's structure.
 
Top