ST Alpha - "Access question: I have a numeric field that ultimately needs a negative number in it." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

Access question: I have a numeric field that ultimately needs a negative number in it.

Posted by Will Hunting (aka JoeMetz) Jul 22 '10, 06:35

I understand that this would be confusing to users who are only used to putting in positive #'s.

Is there a method to VBA update their input (if positive) to a negative # and if it's negative, to leave it alone?

I'm fuzzy on how to do this.

Responses:

I'm sure there is. Does it have to be stored in the table as such? Could you just put it in the query when extracting the number(s)? -- nm - JaxSean Jul 22, 06:55 1
- I figured the easiest way was just to put a validation box that would force the user to put it negative. -- nm - Will Hunting Jul 22, 07:18

Post a message top

Access question: I have a numeric field that ultimately needs a negative number in it.

Replies are disabled on threads older than 7 days.