decimal value problems - Xtreme Visual Basic Talk

11-23-2006, 02:24 AM

cybermonster cybermonster is offline

Newcomer

Join Date: Nov 2006

Posts: 5

decimal value problems

A field in my access database is set to currency however whe i connect the database to my visual basic project using an ADO control the textbox only shows a rounded value which is to 1 decimal place ie. £1.70 in my database is shown as 1.7 in my VB textbox.

Is there any way of still having the currency sign and full value in the textbox whilst still having the database data type set to currency???

thanks

11-23-2006, 02:27 AM

DougT

Ultimate Antique

Administrator
* Expert *

Join Date: Sep 2005

Location: Maldon,Essex, UK

Posts: 3,939

Use the Format Function
eg

Code:

txtValue.Text = Format(sngVal,"##.#0")

__________________
semel insanivimus omnes
S Data in context = Information, S Information in context = Knowledge, S Knowledge in context = Experience
S Experience in context = Wisdom= Data

Posting Rules

You may not post new threads

You may not post replies

You may not post attachments

You may not edit your posts

BB code is On

Smilies are On

[IMG] code is Off

HTML code is Off

Forum Rules