as you will go through pic no.6 i have put a value in numeric field name"GrandTotal" & when i moves down the courser to field name"Nett_Pay" the script must run and should convert the value like (as shown in pic no. 6 the numeric field has a value of 3825 & i wants to convert it E.g. "Rupees Three t...

please see this i have made further changes in script but i wouldn't get the desired results uma shankar

i have changed the same but still it dosen't work please see the attachmentplease see while i am running the script it looks like thisin this screen shoot the curser is positioned at the field name"attended by" but it still dosen't work

i want's to give a dynamic path instead to static path in form database is it possible? it is just because when i am running the form on my home pc it works well but as well as i am shifting it to my office pc along with its database it dosen't works well. rather it behave like a static form as per ...

please see the error file listed belowPlease see the numeric field properties shown in image inserted belowAnd now see the properities of text field along with script in image inserted belownow the problem is when i have rename the caption of numeric field it shows it on screne & it disturbes the fo...

please find the connection string which was created after the connection succeeded as you shown in the screen shoot the:"Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DBQ=C:\Users\UMASHANKAR\Desktop\Survey.accdb;DefaultDir=C:\Users\UMASHANKAR\Desktop;Driver={Microsoft Access Dr...

i have tried the same as instructed by you but it dosent works i have written the sql query as below."SELECT FirstName, MiddleName, LastName, Age, Gender, MonthlyIncome, Profession, Address, PhoneNumber, Email, Mobile FROM Survey;" let me know how i can correct the same.regardsuma shankar

it works very well

sir,it only work if we converts the value from 100000 to 120000 but as well as we move further like 120001 it gets fail & converts the value in usual manner i.e. one hundred twenty thousand one onlyregardsuma shankar

Sir,One more thing i would like to know that how i can set the digit terms in form calculation (i.e. if i have put a figure 100,000 the output come as one hundred thousand instead of one lac ) i have set the digit for lac but it only convert the value of 100000 when i went further it converts the va...