×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Cant format a text box?

Cant format a text box?

Cant format a text box?

(OP)
HI I have a strange eror wherby i can control the format of numbers on some text boxes.

I have an access adp file that is linked to data from a sq server stored proc, but number i want to display as percentages in the format 45.32% aprear as 45.321456768631 as an exampe no mattter what  set the prperties too on the form control.

any ideas anyone??

RE: Cant format a text box?

Where are you displaying the number? In a form? In a report?
If it's a text box, take a minute and look at user-defined formats in Access help.

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

RE: Cant format a text box?

(OP)
o sorry in a text box assigned to a form ive tried using the FOrmat property and decimal places but they seem to be ignored...??

RE: Cant format a text box?

Quote:


take a minute and look at user-defined formats in Access help

Not the format property, user-defined formats. Such as Format(yournumber,"##.##%")

Now,

Quote:


take a minute and look at user-defined formats in Access help

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

RE: Cant format a text box?

(OP)
hi the user defined formats works grate accept once i turn my project into an ade file and install it on a pc using access 2003 runtime all the fields have #Name? in them???

any ideas why that wont work.

Thanks,

RE: Cant format a text box?

#Name refers to a field name in your code that is either mis-spelled, or no longer exists in the new database.

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

RE: Cant format a text box?

(OP)
its the exact same database all i did was convert the file from an adp to an ade thats all thats changed and then put the file onto a pc that only has access run time.  On a PC with full access version the text boxes are ok??

is this a problem with the run time??

RE: Cant format a text box?

Don't know much about the runtime version as I have never used it. I will venture a guess that the linked tables are no longer linked. Is the same DSN installed on the user PC?

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

RE: Cant format a text box?

(OP)
theres no linked tables its an ade file.. everything else works just fine.  most frustrating.

RE: Cant format a text box?

I've come across a similar issue and it was one I didn't find a simple solution to.  When running on my own PC, the text box would display the correct value.  However, when distributed to other end users I was getting an error (probably #Name).

In the end, I replace the text box with a label, and put in an appropriate piece of VBA to 'calculate' and update the label caption.  

OK, so it's a sledgehammer to crack a nut, but it did work.

RE: Cant format a text box?

Quote:


theres no linked tables its an ade file

So where are the tables in the adp that you made the ade from? If you're not linked via ODBC to another RDBMS, then why aren't you using an mdb/mde?

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close