Search results

Thanks Craig. That fixed the 100% problem but now it's rounding. I need exact values, (ie 98.87%).

I have a field in my form that I want to be a %. I want to enter the number and have it display at that %. For example, I may enter "78.86" and after I tab out, I want to see it as 78.86%. I have the text box set to Number and formated for Percent but when I enter a number, almost any number...

I have it linked now, but I can't enter more than one line or I get a message that it would create a duplicate entry. I think I have something linked wrong. I want to be able to add several items in this list all under one Rep's name.

@AccessMSSQL I think I got it. Working great! Thanks!

I can see where you're going with this and it makes sense; however, I'm new to the code side of Access and I'm afraid I'm taking what you wrote quite litterally. Let me make sure I understand. Where "ComboboxX" is listed, I'll enter the exact name of my filed. Where "TableA" is listed, I'll...

I'm creating a form in Access 2007 that evaluates employee performance. In it is a subform that stores "comments" about the employee as suggestions for improvement. The subform is linked to a table that is separate from the main table. Here's my plan: 1. Each new record shows a blank form...

Thank you everyone! All of your advice was extremely helpful. @Isskint, Hiding the column width was genius. Worked like a charm. I have a follow up: I have another section in this same form that will require a similar but not exact solution. I have a drop down list with three choices...

I relatively new to Access but I have a basic understand and have designed many simple databases and forms from scratch; however, I've been given a task at work that is requiring me to do something that is altogether new to me. In a form I created, I need two text fields to auto populate their...