No Word wrap

How can I stop word wrap happening? If the data is too big for the column
then I want it truncated.
Any ideas?Go to the properties of the text box... There is a property named something
like 'Allow automatic expansion''' Make sure it is not checked and you will
be good to go.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Joe90" <Joe90@.discussions.microsoft.com> wrote in message
news:AE9DC820-52DA-4A6B-A17C-0EF0D9354C81@.microsoft.com...
> How can I stop word wrap happening? If the data is too big for the column
> then I want it truncated.
> Any ideas?|||Right click the field in question, click on properties. Uncheck "Can
increase to accomidate contents".
Catadmin
"Joe90" wrote:
> How can I stop word wrap happening? If the data is too big for the column
> then I want it truncated.
> Any ideas?|||Thanks but I already have 'Can Expand' set to 'false'.
That property stops the the textbox being increased in size to fit the text.
The problem I am getting is that the text is being wrapped within the fixed
size textbox, in some case losing the top half of the first line and bottom
half of the second line.
I've discovered that by adjusting the Top & Bottom padding I can stop it
happening but was wondering if there was a property.
Thanks again
"Catadmin" wrote:
> Right click the field in question, click on properties. Uncheck "Can
> increase to accomidate contents".
> Catadmin
> "Joe90" wrote:
> > How can I stop word wrap happening? If the data is too big for the column
> > then I want it truncated.
> >
> > Any ideas?|||I think you just found it. The only other option I can think of is to
re-size the font smaller, which sometimes makes an item unreadable.
Sorry.
Catadmin
"Joe90" wrote:
> Thanks but I already have 'Can Expand' set to 'false'.
> That property stops the the textbox being increased in size to fit the text.
> The problem I am getting is that the text is being wrapped within the fixed
> size textbox, in some case losing the top half of the first line and bottom
> half of the second line.
> I've discovered that by adjusting the Top & Bottom padding I can stop it
> happening but was wondering if there was a property.
> Thanks again
> "Catadmin" wrote:
> > Right click the field in question, click on properties. Uncheck "Can
> > increase to accomidate contents".
> >
> > Catadmin
> >
> > "Joe90" wrote:
> >
> > > How can I stop word wrap happening? If the data is too big for the column
> > > then I want it truncated.
> > >
> > > Any ideas?|||Also, you could use the left function to display only a certain number of
characters. Of course, that works best if you're using Courier, but perhaps
it could help.
Mike G.
"Catadmin" <goldpetalgraphics@.yahoo.com> wrote in message
news:424C4F08-511D-4100-B675-3A6479DDC76B@.microsoft.com...
>I think you just found it. The only other option I can think of is to
> re-size the font smaller, which sometimes makes an item unreadable.
> Sorry.
> Catadmin
> "Joe90" wrote:
>> Thanks but I already have 'Can Expand' set to 'false'.
>> That property stops the the textbox being increased in size to fit the
>> text.
>> The problem I am getting is that the text is being wrapped within the
>> fixed
>> size textbox, in some case losing the top half of the first line and
>> bottom
>> half of the second line.
>> I've discovered that by adjusting the Top & Bottom padding I can stop it
>> happening but was wondering if there was a property.
>> Thanks again
>> "Catadmin" wrote:
>> > Right click the field in question, click on properties. Uncheck "Can
>> > increase to accomidate contents".
>> >
>> > Catadmin
>> >
>> > "Joe90" wrote:
>> >
>> > > How can I stop word wrap happening? If the data is too big for the
>> > > column
>> > > then I want it truncated.
>> > >
>> > > Any ideas?