Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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 October 24th, 2006, 07:17 AM
Authorized User
 
Join Date: Dec 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default Debit and credit formats

Hello all,
I have a budget database.
There is an Expense field in which I have to input minus in front of the amount for debit. The thing is I would like this minus (for debits) to appear automatically whenever I type in an amount BUT not if I type a plus sign in front of the amount (credits).
Ex.
100€ --> -100€ (for debit)
+100 --> 100€ (for credit)
The field is of currency type.
Thanks in advance,
Sven






Similar Threads
Thread Thread Starter Forum Replies Last Post
Credit Card Processor stu9820 ASP.NET 1.0 and 1.1 Basics 3 June 22nd, 2007 02:51 PM
Credit Card Encryption jemacc SQL Server 2000 13 October 23rd, 2006 08:45 PM
ASP credit card p2ptolu Classic ASP Basics 2 March 29th, 2006 08:33 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.