help me pls (MS ACCESS newbie)

They have: 5,633 posts

Joined: Jan 1970

Pls help me with this:

1.How to create a consistent data format in MS ACCESS?
2. How to create a conditional format "For"?
3. Positive, Negative Values?

thanks a lot.

Peter J. Boettcher's picture

They have: 812 posts

Joined: Feb 2000

1. I'm not quite sure what you mean. Do you mean like formatting telephone numbers or postal codes? If so you can use the Input Mask built into Access or you can format the input in code before you pass it to the database.

2. Again, I'm not quite sure what you mean.

3. Just use the Number datatype and anything less than zero just add a (-)

PJ | Are we there yet?
pjboettcher.com

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.