Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB-Aware

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2006, 03:52 PM
KAM KAM is offline
Senior Member
 
Join Date: Jul 2006
Posts: 216
Default Show Format In DBGrid

Hi I have a currency format within my table in access. I currently view this table in a dbgrid and 1.00 in my access database shows as 1 in my table. How can I get it to use the same format.

Thanks
Reply With Quote
  #2  
Old 08-20-2006, 03:57 PM
Strog Strog is offline
Member
 
Join Date: Aug 2006
Posts: 54
Default RE: Show Format In DBGrid

You need to double click on your Table on form and to click with the right button on the window that appeare and then to click "Add fields". Select all fields you need to show on your DBGrid and click Add.

Now click on the field which contains currency and in display format set something like: " ###,###,###,##0.00" ( without quotes ) and that's it! Now you'll get " 1.00" in your DBGrid instead of "1".

"From all the things I've lost
I miss my mind the most..."
Reply With Quote
  #3  
Old 08-20-2006, 04:02 PM
KAM KAM is offline
Senior Member
 
Join Date: Jul 2006
Posts: 216
Default RE: Show Format In DBGrid

Cheers your being a real help on my last few questions. I am new to database linking in delphi you see.

Cheers again,

Kevin
Reply With Quote
  #4  
Old 08-20-2006, 11:55 PM
Strog Strog is offline
Member
 
Join Date: Aug 2006
Posts: 54
Default RE: Show Format In DBGrid

No problem .

"From all the things I've lost
I miss my mind the most..."
Reply With Quote
Reply

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:45 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.