Please Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm new to Access and I'm currently working on setting up my company's
inventory. One of the field is Replacement Value. I'd like to know how to set
up that column so it shows up automatically with a dollar sign.
Thanks
 
It depends on where you want it to show up. It is not a good practice to put
a format on a table field, rather you should format the field on forms or
reports displayed to the user.

If you are planning to allow users to work directly with tables, rethink
what you are doing and read some literature in developing Access applications.
 
If you want the dollar sign everywhere you display Replacement Value, open
the table in design view, select the Replacement Value field and set the
appropriate format at the bottom of the screen. If you want the dollar sign
in only a specific form or report, open the form or report in design view,
select the Replacement Value field, click on the Properties icon in the menu
at the top of the screen, click on the Format tab in the Properties dialg
that apppears and set the format appropriately.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top