A real easy one I think??

  • Thread starter Thread starter Earl.AKA J.Alladien in access forum!!
  • Start date Start date
E

Earl.AKA J.Alladien in access forum!!

Hello All,

I have following table
kode description
format**
4019 WATERHEATER 30GAL 220V.USA UPR /PRODUCTS/4019.bmp
4040 WATERHEATER 30GAL 220V.USA LOW /PRODUCTS/4040.bmp

I would like to display the kode_field as (see format**)
How do I do this?

Thanks in advance!
 
So what I mean is

how do I format 4019 as /PRODUCTS/4019.bmp

etc etc.
 
Try:

Format(kode_field,"\/\P\R\O\D\U\C\T\S\/#\/\.\b\m\p")

Ken Sheridan
Stafford, England
 
Thanks Ken,

I got it to work but I had to modify it to:

Foto: Format([KODE],"""/PRODUCTS/""&&&&&&&&&&&&&&&&&"".bmp""")

Earl
 
You could also concatenate:
Foto: "/PRODUCTS/" & [KODE] & ".bmp"

It isn't formatting, but it is another way to get the same end result.

"Earl.AKA J.Alladien in access forum!!"
Thanks Ken,

I got it to work but I had to modify it to:

Foto: Format([KODE],"""/PRODUCTS/""&&&&&&&&&&&&&&&&&"".bmp""")

Earl

Ken Sheridan said:
Try:

Format(kode_field,"\/\P\R\O\D\U\C\T\S\/#\/\.\b\m\p")

Ken Sheridan
Stafford, England
Click to expand...
Click to expand...
 
Back
Top