Fromatting question.

[Shawn]

If I want to get the number of characters returned from a database query and
then set the width of a control, what is a good formula or good practice to
do this? I have been using things like,

Dim result as Integer = Query.Length
label1.width = result * 10

But of course, the longer the text returned from the query, the wider the
control.

[marcmc]

I would imagine you would need to set some sort of fixed length for Label1.
Why not check the maximum values of the column you are seeking in the
database table, then set a bendhmark maximum sixe you will allow your labelto
become. If the length of the lebel exceeds your benchmark maximum showa
message a resize it to something more realistic within the boundaries of your
application.

"Shawn" wrote:

If I want to get the number of characters returned from a database query and
then set the width of a control, what is a good formula or good practice to
do this? I have been using things like,

Dim result as Integer = Query.Length
label1.width = result * 10

But of course, the longer the text returned from the query, the wider the
control.

[Chris]

Shawn wrote:

If I want to get the number of characters returned from a database query and
then set the width of a control, what is a good formula or good practice to
do this? I have been using things like,

Dim result as Integer = Query.Length
label1.width = result * 10

But of course, the longer the text returned from the query, the wider the
control.

You need to use the measurestring method of a graphics object. AFAIK,
You'll need the graphics object from control you are going to put the
text in.

Hope this helps.
Chris

[Herfried K. Wagner [MVP]]

"Shawn" <sh**********@ccci.org> schrieb:

If I want to get the number of characters returned from a database query
and then set the width of a control, what is a good formula or good
practice to do this? I have been using things like,

Dim result as Integer = Query.Length
label1.width = result * 10

But of course, the longer the text returned from the query, the wider the
control.

Check out 'Graphics.MeasureString'.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Shawn]

Took some tweaking, but that worked much better so far.

Thanks guys!!

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:OW**************@TK2MSFTNGP14.phx.gbl...

"Shawn" <sh**********@ccci.org> schrieb:

If I want to get the number of characters returned from a database query
and then set the width of a control, what is a good formula or good
practice to do this? I have been using things like,

Dim result as Integer = Query.Length
label1.width = result * 10

But of course, the longer the text returned from the query, the wider the
control.

Check out 'Graphics.MeasureString'.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>