regarding autonumber as custom output result

[vbaInet]

Glad you got that sorted and thanks for posting back with your success.

 

[Khalid_Afridi]

Hi naina!

Good you sorted that out, but I never seen varchar in VBA or Access query its rather use in SQL server fields types

 

[naina]

Hi naina!

Good you sorted that out, but I never seen varchar in VBA or Access query its rather use in SQL server fields types

Dear Khalid
You are 100% Right.

but My Application is based on A2003 adp with Sql 2000 Server. that's why I can Easily use Sql Data type

<<<<<<Naina>>>>>>>>

 

[Khalid_Afridi]

Great!

But you never said that you have adp with sql server data linked or may be i missed it, and if you remember, one of my post I mentioned that if you want such formats then your field should have a text data type and which you have done at last.

Glad you have sorted that out

 

[naina]

Dear khalid
I Definitely mention whatever System I use
Here is My Old Post of Current Thread
<<<<<<<<<<<<<
same error when run this in Sql

SELECT Format([AuditID],"00000") As AuditNum FROM AuditTrailT

Note: My Application is Based on A2003 ADP & Sql 2000 Server.
>>>>>>

And I've not changed my original Data type(int) ,whatever change(Convert) I do is run time

And Last of all Sorry for Misunderstanding.

<<<<<<<<<<Naina>>>>>>>>>>

 

[Khalid_Afridi]

Ahh naina!

You are right, that's all you are using SQL server database I missed that.
naina is also a good name, what does it mean BTW (is it beautiful eyes?)