populate a txtBox with 41. (nothing after the .)

dogdays

Active Member
Joined
Apr 28, 2008
Messages
434
Office Version
  1. 2007
Access 2003 XP
I have a global string gstrEndLat, it is initialzed to "41. "
I have a txtBox txtEndLat that I wish to populate with the 41.
then place focus on the space to the right of the dot

gstrEndLat = "41. "
txtEndLat.value = gstrEndLat

Access, in its infinite wisdom, drops the dot and I end up with 41
I also tried 41.0 same result.
How can I do this?

tia Jack
 
Thank you Skaas. I changed the text box to standard and all is well.
Post closed.

Jack
 
Upvote 0

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Often the most complex problems have the simplest solution

Glad I could help

**side note: To norie - whom sparked my memory**
 
Upvote 0

Forum statistics

Threads
1,215,972
Messages
6,128,021
Members
449,414
Latest member
sameri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top