How to format a field

Wrox Programmer Forums

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
How to format a field

VB How-To Ask your "How do I do this with VB?" questions in this forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

March 3rd, 2004, 09:00 AM

predal

predal is offline

Authorized User

Join Date: Mar 2004

Posts: 17

Thanks: 0

Thanked 0 Times in 0 Posts

Default

How to format a field

Hi guys

How can you format a field containing numbers(double) directly from a querry. The database is SQLServer. I need it so I can link the result as the datasource for a MSHFlexGrid control.

Many thanks

Lucian Preda
[email protected]

__________________
Lucian Preda
[email protected]

Old

September 30th, 2004, 06:41 AM

Lalit_Pratihari Lalit_Pratihari is offline

Lalit_Pratihari is offline

Authorized User

Join Date: Sep 2004

Posts: 55

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via AIM to Lalit_Pratihari

Default

Hi,

You can use CAST() or CONVERT() function of SQL server.

Thanks,

Lalit
Life Means More...;)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
AUTO FORMAT field	mfahmyg	Access	2	April 4th, 2008 07:24 AM
Format Date to time field	KennethMungwira	VB.NET	3	November 17th, 2003 11:48 AM
Field format from Text to Memo	sassenach	Classic ASP Databases	0	July 24th, 2003 06:19 AM
How to format a Date field	Niaz	SQL Server 2000	2	June 25th, 2003 12:43 AM