ASP - how to put comma in DW

Sure, open your access database pick your table with the number field you
want to format, Click the triangle with the pencil next to it (Design View)
Under data type
Make sure its a number then in field properties click in the format field a
dropdown box will show up click the drop down and select the format display
layout you want for your number to show up in the field. (standard) is what
you probably want.
Dave
"Techy" <anwar@clickbahrain.com> wrote in message
news:fou8q3$5ct$1@forums.macromedia.com...
> hi baxter...
>
> can you tell me how to do that in access please....
>
> i am not able to figure it out
>
> thanks
>
>

hi baxter...

can you tell me how to do that in access please....

i am not able to figure it out

thanks

"Techy" <anwar@clickbahrain.com> wrote in message
news:fom7f9$6l7$1@forums.macromedia.com...
> hii there
>
> using ASP and MS Access
>
> I am retrieving data from a number field like - "89000"
>
> this field stores the price of the product
>
> I wouuld like to put a comma after 2 digits like 89,000
>
> and would like to put comma after 3 digits like 485,000
>
> teh recordset when receives the data only pull the complete text in the
> row how can i put a comma after i receive from the data something like
> this 89,000 or 485,000 etc.

Select the field in your page and then look at the Bindings Panel - there
should be a down-arrow in the Format column - take a look at the options
there; there might be one that suits what you need

You can format the number field in your access database. in table design
view.
Dave
"Techy" <anwar@clickbahrain.com> wrote in message
news:fom7f9$6l7$1@forums.macromedia.com...
> hii there
>
> using ASP and MS Access
>
> I am retrieving data from a number field like - "89000"
>
> this field stores the price of the product
>
> I wouuld like to put a comma after 2 digits like 89,000
>
> and would like to put comma after 3 digits like 485,000
>
> teh recordset when receives the data only pull the complete text in the
row
> how can i put a comma after i receive from the data something like this
> 89,000 or 485,000 etc.
>
> thanks
>
>