If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
TextBox - ComboBox Data Format Inconsistency
I have an Access Project which has several combo box fields that have a
lookup table. In SQL server, I have a Data Transformation (DTS) routine to convert selected records, from the same table used in Access, to delimited text. However, when I look at the fields in SQL Server that were combo boxes in Access, the data has gone through some conversion process and is different (e.g. OCC024000 is 1970 or something like that.) Of course, in SQL Server the data is viewed as a simple text box. I tried this in Access and the same thing happend. That is, if I put data into the form combo box, selecting data from the drop down lookup list, and then later view the same data in table format where the fields are defined as simple text boxes, the data has been changed just as in SQL Server. Why is data, which is entered into a form or table using a combo box lookup, not compatible with a view that uses a simple text box for the same fields?? -- Paul |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Chart Format generated from a Pivot Table Data | Victor | Charts and Charting | 1 | October 20th, 2004 05:58 AM |
access chart data table number format | Yolanda | Running & Setting Up Queries | 1 | September 21st, 2004 06:59 PM |
format in MS Access chart data table | Yolanda | General Discussion | 0 | September 19th, 2004 10:47 PM |