Hello all \. Iam new to this group. So if I do anything wrong i do
not mean it.
Here is my question:
I have a currency field (i.e. $24.50). I want to change it using an
update query to a text field in the same table. Here is the kicker. I
need it in the format 9999999.99 (ten spaces with change in the last
two spaces). When I try to convert it into text it drops off the last
zero.
RE: Currency/ Number fields ... Simple way to do this is to format the text box as follows: ... If there is an entry of 0 - this will be hidden. ... > Does anyone no of a way that when I create a number or currency field in a ... > table that the corresponding field on my form is blank and not with a "Zero"... (microsoft.public.access.forms)
Re: Currency/ Number fields ... So if I just wanted to hide the zero what ... > If there is an entry of 0 - this will be hidden. ... > format as you like. ... >> Does anyone no of a way that when I create a number or currency field in ... (microsoft.public.access.forms)
Re: Currency conversion ... I agree that the way Access works with regard to currency...format at all with a currency field, ... again it displays per regional settings.... (microsoft.public.access.modulesdaovba)
Re: I lose my number formatting in the mail merge? ... I found a way to format using text, ... might not be my best option since the currency field in the spreadsheet may ... I am using Word 2007 and Excel 2007. ...currency formatting over from Excel to Word. ... (microsoft.public.excel.misc)
Re: Pennies only ... Is it possible to format a currency field so that no dollars show up? ... John W. Vinson [MVP]... (microsoft.public.access.forms)
