Recent content by pbbriggs

Gavin, your code is really slick. Works like a charm. I am going to write some quick code to revert back to formulas (and then re-run the formatting code) any time a value changes somewhere, but this was a great help. Thanks. Stars to you both - both solutions are equally viable depending on...

Thanks, Skip and Gavin... Right after I posted (isn't that always the way?) I thought of conditional formatting based upon the original value (A1). It works fine, and I can live with the red text it produces for the negative numbers. I am going to try Gavin's code; I am not wild about losing...

Hi, I have an Excel formatting question that I thought was pretty straightforward, but nothing seems to be giving me the desired result. Basically, I want to combine a number (in one cell) with text in another cell, while retaining the correct formatting of the number. It is all working...

Have a star, Pampers, for solving this issue for users of more current Access versions! I am quite sure that your original formatting suggestion: #,##0, would work just fine for later versions of Access. Thanks for the help!

The formats with the periods instead of commas aren't taking, either. As soon as I leave the format field, the period disappears. I also just tried setting the format through code (in the OnOpen event of the form). I don't get an error, but nothing happens. Maybe Access 97 doesn't recognize...

Don't laugh, we're on Access 97. :)

Hi again Pampers, Thanks for your persistence! I would definitely like to use one of the format options (vs. your unbound textbox suggestion) because my fields allow entry/edit; they are not just for viewing. The strange thing is, even though my regional settings are set correctly, whenever I...

Thanks Pampers. For some reason, when I enter that into the Format box, the final comma is dropped as soon as I leave the field (even if I put the semicolon after it), so it reads #,##0 . So, then the number just formats as: 459,999. I don't know if there is some trick to custom formatting in...

Hi, I have a form that is basically displaying a financial worksheet/cash flow statement. I would like the figures to be shown in thousands (i.e., the last three digits would not show, and the digit before the final comma would be rounded up or down accordingly). For example, I'd like 456,000...

#REF generally means there is something wrong with the range it is trying to look in (usually it means the cell(s) originally referenced in the formula have been deleted) Do you see #REF in the formula itself (e.g., LOOKUP(B2,#REF,2,false), or just in the result? If you know the range you want...

It means that someone has already named a range (called "emp"), and this is where your lookup formula is looking. To see what the range is, you can either choose "emp" from the name box (just to the left of the formula bar)... ... or use the menu option "Insert - Name - Define" to see a list...

livvie, I think it would help if you could explain a little better what you are trying to do. Are you trying to permanently highlight some records? Are you trying to highlight some records temporarily so that when the user clicks a command button, s/he knows which records are going to be...

How does your command button know for which record(s) it should be passing details to the other table? Could you have a checkbox (or some other true/false field) in your original table/query (upon which the form is based), and then just make all fields locked on the form except the checkbox...

By "select button" do you mean something like an option button or check box (i.e., one button for each record, that pertains only to that record)? Are you, for example, trying to highlight a row when the "select button" for that row is checked? If that is what you are trying to do (and you are...

bobbobruns12, I don't use macros, but it sounds like your macro may never be called if you use the "AfterUpdate" event of the DLookUp text box (CityCode) because - in the event the lookup city/state is not found, the box is not updated. Does the user click a button after entering the...